Maximum Capacity Specifications (64-bit)
This topic applies only to SQL Server 2000 (64-bit).
The first table specifies maximum capacities that are the same for all editions of Microsoft® SQL Server™ 2000. The second and third tables specify capacities that vary by edition of SQL Server 2000 and the operating system.
This table specifies the maximum sizes and numbers of various objects defined in Microsoft SQL Server databases, or referenced in Transact-SQL statements. The table does not include the SQL Server 2000 Windows® CE Edition.
| Maximum sizes/numbers | ||
|---|---|---|
| Object | SQL Server 2000 (32-bit) | SQL Server 2000 (64-bit) |
| Batch size | 65,536 * Network Packet Size1 | 65,536 * Network Packet Size1 |
| Bytes per short string column | 8,000 | 8,000 |
| Bytes per text, ntext, or image column | 2 GB-2 | 2 GB-2 |
| Bytes per GROUP BY, ORDER BY | 8,060 | 8,060 |
| Bytes per index | 900 | 9002 |
| Bytes per foreign key | 900 | 900 |
| Bytes per primary key | 900 | 900 |
| Bytes per row | 8,060 | 8,060 |
| Bytes in source text of a stored procedure | Lesser of batch size or 250 MB | Lesser of batch size or 250 MB |
| Clustered indexes per table | 1 | 1 |
| Columns in GROUP BY, ORDER BY | Limited only by number of bytes | Limited only by number of bytes |
| Columns or expressions in a GROUP BY WITH CUBE or WITH ROLLUP statement | 10 | 10 |
| Columns per index | 16 | 16 |
| Columns per foreign key | 16 | 16 |
| Columns per primary key | 16 | 16 |
| Columns per base table | 1,024 | 1,024 |
| Columns per SELECT statement | 4,096 | 4,096 |
| Columns per INSERT statement | 1,024 | 1,024 |
| Connections per client | Maximum value of configured connections | Maximum value of configured connections |
| Database size | 1,048,516 TB | 1,048,516 TB |
| Databases per instance of SQL Server | 32,767 | 32,767 |
| Filegroups per database | 256 | 256 |
| Files per database | 32,767 | 32,767 |
| File size (data) | 32 TB | 32 TB |
| File size (log) | 32 TB | 32 TB |
| Foreign key table references per table | 253 | 253 |
| Identifier length (in characters) | 128 | 128 |
| Instances per computer | 16 | 16 |
| Length of a string containing SQL statements (batch size) | 65,536 * Network packet size1 | 65,536 * Network packet size1 |
| Locks per connection | Maximum locks per server | Maximum locks per server |
| Locks per instance of SQL Server | Up to approximately 16,000,000 (limited by memory) | Limited only by memory |
| Nested stored procedure levels | 32 | 32 |
| Nested subqueries | 32 | 32 |
| Nested trigger levels | 32 | 32 |
| Nonclustered indexes per table | 249 | 249 |
| Objects concurrently open in an instance of SQL Server4 | 2,147,483,647 per database (depending on available memory) | 2,147,483,647 per database (depending on available memory) |
| Objects in a database | 2,147,483,6473 | 2,147,483,6473 |
| Parameters per stored procedure | 1,024 | 1,024 |
| REFERENCES per table | 253 | 253 |
| Rows per table | Limited by available storage | Limited by available storage |
| Tables per database | Limited by number of objects in a database3 | Limited by number of objects in a database3 |
| Tables per SELECT statement | 256 | 256 |
| Triggers per table | Limited by number of objects in a database3 | Limited by number of objects in a database3 |
| UNIQUE indexes or constraints per table | 249 nonclustered and 1 clustered | 249 nonclustered and 1 clustered |
1 Network Packet Size is the size of the tabular data scheme (TDS) packets used to communicate between applications and the relational database engine. The default packet size is 4 KB, and is controlled by the network packet size configuration option.
2 The maximum number of bytes in any key cannot exceed 900 in SQL Server 2000. You can define a key using variable-length columns whose maximum sizes add up to more than 900, provided no row is ever inserted with more than 900 bytes of data in those columns. For more information, see the Maximum Size of Index Keys topic in SQL Server 2000 32-bit Books Online.
3 Database objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, defaults, and constraints. The sum of the number of all these objects in a database cannot exceed 2,147,483,647.
Maximum Numbers of Processors Supported by the Editions of SQL Server 2000 (64-bit)
SQL Server 2000 (64-bit) Enterprise Edition supports 32 processors on symmetric multiprocessing (SMP) computers.
