Thursday, April 16, 2009

Maximum Capacity Specifications for SQL Server 2005

  • Batch size : -> 65,536 * Network Packet Size
  • Bytes per short string column : -> 8000
  • Bytes per text, ntext, image, varchar(max), nvarchar(max), varbinary(max), or XML column : -> 231 -1 bytes/p>
  • Bytes per GROUP BY, ORDER BY : -> 8060
  • Bytes per index : -> 900
  • Bytes per foreign key : -> 900
  • Bytes per primary key : -> 900
  • Bytes per row : -> 8060
  • Bytes in source text of a stored procedure : -> Lesser of batch size or 250 MB
  • Clustered indexes per table : -> 1
  • Columns in GROUP BY, ORDER BY : -> Limited only by number of bytes
  • Columns or expressions in a GROUP BY WITH CUBE or WITH ROLLUP statement : -> 10
  • Columns per index : -> 16
  • Columns per foreign key : -> 16
  • Columns per primary key : -> 16
  • Columns per base table : -> 1024
  • Columns per SELECT statement : -> 4096
  • Columns per INSERT statement : -> 1024
  • Connections per client : -> Maximum value of configured connections
  • Database size : -> 1,048,516 terabytes
  • Databases per instance of SQL Server : -> 32767
  • Filegroups per database : -> 32767
  • Files per database : -> 32767
  • File size (data) : -> 32 terabytes
  • File size (log) : -> 32 terabytes
  • Foreign key table references per table : -> 253
  • Identifier length (in characters) : -> 128
  • Instances per computer : -> 50
  • Length of a string containing SQL statements (batch size) : -> 65,536 * Network packet size
  • Locks per connection : -> Maximum locks per server
  • Locks per instance of SQL Server : -> Up to 2,147,483,647
  • Nested stored procedure levels : -> 32
  • Nested subqueries : -> 32
  • Nested trigger levels : -> 32
  • Nonclustered indexes per table : -> 249
  • Objects concurrently open in an instance of SQL Server : -> 2,147,483,647 per database (depending on available memory)
  • Objects in a database : -> 2147483647
  • Parameters per stored procedure : -> 2100
  • Parameters per user-defined function : -> 2100
  • REFERENCES per table : -> 253
  • Rows per table : -> Limited by available storage
  • Tables per database : -> Limited by number of objects in a database
  • Tables per SELECT statement : -> 256
  • Triggers per table : -> Limited by number of objects in a database
  • UNIQUE indexes or constraints per table : -> 249 nonclustered and 1 clustered
  • No comments:

    Post a Comment