Este documento muestra los tamaños máximos de varios objetos definidos en las bases de datos de SQL Server, no se incluyen para la versión de Microsoft SQL Server 2000 Windows CE
|
|
Maximum sizes/numbers |
|
|
Object
|
SQL Server 7.0
|
SQL Server 2000
|
|
Batch size
|
65,536 * Network Packet Size1
|
65,536 * Network Packet Size1
|
|
Bytes per sort 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 per GROUP BY, ORDER BY
|
Limited only by number of bytes per GROUP BY, ORDER BY
|
|
Columns or expressions in a GROUP BY WITH CUBE or WITH ROLLUP statement
|
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 TB3
|
1,048,516 TB3
|
|
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)
|
4 TB
|
32 TB
|
|
Foreign key table references per table
|
253
|
253
|
|
Identifier length (in characters)
|
128
|
128
|
|
Instances per computer
|
N/A
|
16
|
|
Length of a string containing SQL statements (batch size)
|
65,536 * Network packet size1
|
65,536 * Network packet size1
|
|
Locks per connection
|
Max. locks per server
|
Max. locks per server
|
|
Locks per instance of SQL Server
|
2,147,483,647 (static)
40% of SQL Server memory (dynamic) |
2,147,483,647 (static)
40% of SQL Server memory (dynamic) |
|
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 (or available memory)
|
2,147,483,647 (or available memory)
|
|
Objects in a database
|
2,147,483,6474
|
2,147,483,6474
|
|
Parameters per stored procedure
|
1,024
|
2,100
|
|
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 database4
|
Limited by number of objects in a database4
|
|
Tables per SELECT statement
|
256
|
256
|
|
Triggers per table
|
Limited by number of objects in a database4
|
Limited by number of objects in a database4
|
|
UNIQUE indexes or constraints per table
|
249 nonclustered and 1 clustered
|
249 nonclustered and 1 clustered
|
1 Network Packet Size es el tamaño de los paquetes “tabular data scheme” (TDS) usados para comunicarse entre aplicaciones y el motor de base de datos. El tamaño por default es de 4KB, y se configura en la opcion network packet size.
2 El máximo número de bytes en una llave no puede exceder de 900 in SQL Server 2000. 3 Los datos no pueden exeder 2 GB cuando se utiliza la versión de SQL Server 2000 Desktop Engine (MSDE 2000) o Microsoft Data Engine (MSDE) 1.0
4 Los objetos de la base de datos incluyen todas las tables, vistas, store procedures, extend procedures, triggers, reglas, defaults y constraints. La suma del número de objetos en la base de datos no puede exceder de 2,147,483,647.
2 El máximo número de bytes en una llave no puede exceder de 900 in SQL Server 2000. 3 Los datos no pueden exeder 2 GB cuando se utiliza la versión de SQL Server 2000 Desktop Engine (MSDE 2000) o Microsoft Data Engine (MSDE) 1.0
4 Los objetos de la base de datos incluyen todas las tables, vistas, store procedures, extend procedures, triggers, reglas, defaults y constraints. La suma del número de objetos en la base de datos no puede exceder de 2,147,483,647.
Máximo número de procesadores soportados en cada una de las versiones de SQL Server 2000
Esta tabla muestra el máximo número de procesadores que SQL Server puede soportar en cada una de sus ediciones. Es posible instalar SQL Server en un servidor que tenga más procesadores que los usados por SQL Server, el engine de base de datos solo utilizara los que se indican en la tabla.
|
Operating System |
Enterprise Edition |
Standard Edition |
Personal Edition |
Developer Edition |
Desktop Engine (MSDE 2000) |
SQL Server CE |
Enterprise Evaluation Edition
|
|
Microsoft Windows 2000 DataCenter
|
32
|
4
|
2
|
32
|
2
|
N/A
|
32
|
|
Windows 2000 Advanced Server
|
8
|
4
|
2
|
8
|
2
|
N/A
|
8
|
|
Windows 2000 Server
|
4
|
4
|
2
|
4
|
2
|
N/A
|
4
|
|
Windows 2000 Professional
|
N/A
|
N/A
|
2
|
2
|
2
|
N/A
|
2
|
|
Microsoft Windows NT® 4.0 Server, Enterprise Edition
|
8
|
8
|
2
|
8
|
2
|
N/A
|
8
|
|
Windows NT 4.0 Server
|
4
|
4
|
2
|
4
|
2
|
N/A
|
4
|
|
Windows NT 4.0 Workstation
|
N/A
|
N/A
|
2
|
2
|
2
|
N/A
|
2
|
|
Microsoft Windows 98
|
N/A
|
N/A
|
1
|
Use Desktop Engine
|
1
|
N/A
|
N/A
|
|
Microsoft Windows CE
|
N/A
|
N/A
|
N/A
|
N/A
|
N/A
|
1
|
N/A
|
Máxima cantidad de memoria física que soporta cada una de las versiones de SQL Server
Esta tabla muestra la máxima memoria física o RAM que SQL Server 2000 puede soportar para cada una de sus versiones.
|
Operating System |
Enterprise Edition |
Standard Edition |
Personal Edition |
Developer Edition |
Desktop Engine (MSDE 2000) |
SQL Server CE |
Enterprise Evaluation Edition
|
|
Windows 2000 DataCenter
|
64 GB
|
2 GB
|
2 GB
|
64 GB
|
2 GB
|
N/A
|
64 GB
|
|
Windows 2000 Advanced Server
|
8 GB
|
2 GB
|
2 GB
|
8 GB
|
2 GB
|
N/A
|
8 GB
|
|
Windows 2000 Server
|
4 GB
|
2 GB
|
2 GB
|
4 GB
|
2 GB
|
N/A
|
4 GB
|
|
Windows 2000 Professional
|
N/A
|
N/A
|
2 GB
|
2 GB
|
2 GB
|
N/A
|
2 GB
|
|
Windows NT 4.0 Server, Enterprise Edition
|
3 GB
|
2 GB
|
2 GB
|
3 GB
|
2 GB
|
N/A
|
3 GB
|
|
Windows NT 4.0 Server
|
2 GB
|
2 GB
|
2 GB
|
2 GB
|
2 GB
|
N/A
|
2 GB
|
|
Windows NT 4.0 Workstation
|
N/A
|
N/A
|
2 GB
|
2 GB
|
2 GB
|
N/A
|
2 GB
|