Maximum Capacity Specifications for SQL Server 2005

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


  • Comments

    Author: Venkatesan Prabu .J30 May 2008 Member Level: Gold   Points : 2

    Useful one Shiv shankar.
    Regards,
    Venkatesan Prabu . J

    Author: Mahesh Raj07 Jun 2008 Member Level: Gold   Points : 1

    This is very good information,Continue posting such useful articles.

    Author: sivakumar08 Jun 2008 Member Level: Silver   Points : 0

    Hi

    This is useful one.

    Author: Anil Kumar Pandey14 Apr 2009 Member Level: Diamond   Points : 1

    hi,

    Shiva,

    Very very useful article. This will provide a lot of information to us.

    Keep posting the article and resources like this




  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: