Maximum capacity
Add information - September 2001
The first table illustrates the same maximum capacity for all Microsoft? SQL Server? 2000 versions. The second and third tables illustrate different capacities varying the version of SQL Server 2000 and the operating system.
The following table illustrates the maximum value (quantity or size) of the various objects defined in the Microsoft SQL Server database or referenced in the Transact-SQL statement. The following table does not include the Microsoft SQL Server 2000 Windows® CE version.
Maximum value (quantity or size) Object SQL Server 7.0sql Server 2000 Batch Size 65,536 * Network Packet Size 165,536 * Network Packet Size 1 Each Sort Route 80008,000 Each Text, Ntext, Ntext , Or image number 2 GB-22 GB-2 Each group by, the byte number of ORDER BY 8, 0608, 060 Number of bytes in each index 9009002 Number of bytes of each foreign body 900900 The byte number of primary keys 900900 Each line byte number 8,0608,060 Stores the number of bytes in the process source text, a smaller, or 250 MB batch size, less than 250 MB, each data sheet The number of columns of the column of the index 11Group By, the number of columns in the order by each group by, the number of bytes of the order by clause is limited to each group by, the order by the order of the order, the number of the number of clauses Group by with cube or WITH ROLLUP statement Columns or Expressions 10 Each index number 1616 Each foreign key number 1616 Each primary key number 1616 Each base data table 1,0241,024 Each SELECT The number of statements 4,0964,096 Each INSERT statement is 1,0241,024 Each client connection number The maximum value of the configured connection is configured. The maximum database size 1,048,516 TB31, 048, 516 TB3 Each SQL Server instance database number 32, 76732, 767 Each database of file groups 256256 per database number 32, 76732, 767 file size (data) 32 TB32 TB file size (log) 4 TB32 TB Each Foreign key table references 253253 identifier length (in character meter) 128128 Each computer's instance number 6 includes a string length of the SQL statement (batch size) 65, 536 * network data packet size 165, 536 * network data packet size 1 Each connection number of locks Each server Maximum lock number Each server is the maximum number of locks. Each SQL Server instance is 2,147,483,647 (static) SQL Server 40% memory (dynamic) 2,147,483,647 (static) SQL Server 40% Memory (Dynamic) Nesting Storage Process Layer 3232 Nested Subrout 3232 Nested Trigger Layer 3232 Number of Non - integrated Codes of Each Data Table 429249 SQL Server instances Open the number of objects at the same time 42,14 7,483,647 (or available memory) 2,147,483,647 (or available memory) A number of objects in each database 2, 147, 483, 64742, 147, 483, 6474 Each stored procedure 1,0242,100 each data table Reference number 253253 The number of data sheets is subject to the available storage resource limits the data table of the available storage resources to limit the number of data tables per database is limited by the number of objects in the database. 4 Data table of each SELECT statement is limited by the number of objects in the database. Number 256256 The number of triggers for each data table is limited by the number of objects in the database. 4 is limited by the number of objects in the database 4 Unique index of each data table 249 non-aggregated indexes and 1 Aggregate index 249 non-aggregated indexes and 1 aggregation index
1 Network Packet Size is the size of the Table Format Data Scheme (TDS) packet, which is used for communication between the application and the relational database engine. The default packet size is 4 KB, controlled by the Network Packet Size configuration option. 2 In SQL Server 2000, the maximum number of bytes of any keys cannot exceed 900. You can define the key using a variable length column, as long as the data is not inserted in this column, the maximum size can be 900 or more. For more information, see the maximum value of the index key. 3 When using SQL Server 2000 Desktop Engine or Microsoft Data Engine (MSDE) 1.0, the size of the database cannot exceed 2 GB. 4 Database objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, defaults, and constraints. The total number of all objects in a database must not exceed 2,147,483,647. Maximum number of processors supported by SQL Server 2000
The following table lists the maximum number of processors that can be used on the database engine in each SQL Server 2000 version. The number of processors installing the SQL Server computer can be greater than the number of processors required by the version of the database engine, but the number of processors used by the database engine will not be greater than the number specified in the table below. For example, you can install the SQL Server standard version on a Windows 2000 Advanced Server computer with 8 processors, but the processor used by the database engine will not exceed 4.
OS Enterprise Edition Standard Edition Personal Edition Developer Edition Desktop EngineSQL Server CE Enterprise Evaluation Edition, Microsoft Windows 2000 DataCenter3242322 temporary lack 32Windows 2000 Advanced Server84282 temporary lack 8Windows 2000 Server44242 temporary lack 4Windows 2000 Professional temporary shortage of temporary shortage of 222 temporary lack 2Microsoft Windows NT? 4.0 Server Enterprise Edition 88282 Temfering 8WINDOWS NT 4.0 Server44242 Temporary 4Windows NT 4.0 Workstation Tempa Leading 222 Temporary 2MICROSOFT Windows 98 Temporary Music 1 Using Desktop Engine1 Temporal Missing Microsoft WINDOWS CE Tempanies 1 temporary
The maximum physical memory supported by SQL Server 2000 version
The following table lists the maximum physical memory volume or RAM supported by the data engine in each SQL Server 2000 version.
Operating system Enterprise Edition Standard Edition Personal Edition Desktop Enginesql Server CE Enterprise Evaluation Edition Windows 2000 Datacenter64 GB2 GB2 GB64 GB2 GB Temporary 64 GBWINDOWS 2000 Advanced Server8 GB2 GB2 GB8 GB2 GB Temporary 8 GBWINDOWS 2000 Server4 GB2 GB2 GB4 GB2 GB Temporary 4 GBWINDOWS 2000 Professional Terminal Lake 2 GB2 GB2 GB Temporary 2 GBWINDOWS NT 4.0 Server Enterprise Edition 3 GB2 GB2 GB3 GB2 GB Temporary 3 GBWINDOWS NT 4.0 Server2 GB2 GB2 GB2 GB2 GB Temporary Mixed 2 GBWINDOWS NT 4.0 WORKSTATION Temporary 2 GB2 GB2 GB Temporary 2 GB
