Limite en el numero de bases de datos

26/09/2003 - 02:35 por andsilva | Informe spam
Saludos cordiales,

me preguntaba si alguno de ustedes sabe de un limite de bases de datos para
un SQL Server 2000.

Gracias

Andres

Preguntas similare

Leer las respuestas

#1 Fernando España
26/09/2003 - 03:30 | Informe spam
Maximum Capacity Specifications
The first table specifies maximum capacities that are the same for all
editions of Microsoft® SQL ServerT 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 Microsoft® SQL Server 2000T Windows®
CE Edition.

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 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
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
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 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 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 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 Maximum Size of
Index Keys.
3 The size of a database cannot exceed 2 GB when using the SQL Server 2000
Desktop Engine or the Microsoft Data Engine (MSDE) 1.0.
4 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
This table shows the number of processors that the database engine in each
SQL Server 2000 edition can support on symmetric multiprocessing (SMP)
computers.




Operating System

Enterprise Edition

Standard Edition

Personal Edition

Developer Edition

Desktop Engine

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


Maximum Amount of Physical Memory Supported by the Editions of SQL Server
2000
This table shows the maximum amount of physical memory, or RAM, that the
database engine in each SQL Server 2000 edition can support.




Operating System

Enterprise Edition

Standard Edition

Personal Edition

Developer Edition

Desktop Engine

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




Fernando España

el 95% de las instrucciones que precisan de un
CURSOR se puede hacer sin ellos y mas
Eficientemente.--

BRIGADA AINTI-CURSORES


****************************************



"andsilva" wrote in message
news:
Saludos cordiales,

me preguntaba si alguno de ustedes sabe de un limite de bases de datos


para
un SQL Server 2000.

Gracias

Andres


Respuesta Responder a este mensaje
#2 Miguel Egea
26/09/2003 - 20:17 | Informe spam
En cualquier caso, aunque el límite fisico sean 32727 es simplemente por que
el programador que lo desarrolló puso ese tipo de datos en el campo
correspondiente de la tabla sysdatabases. No creo que sea una buena idea
tener siquiera cientos o miles de bases de datos por instancia, solamente
abrir el e.m. puede ser una odisea.(porque e.m. está regular de programado
en la optimización del accesso, claro, no porque sean muchos registros para
SqlServer)


=Miguel Egea
http://www.portalsql.com
Microsoft SQL-SERVER MVP.
Brigada Anti-Cursores
Aviso de Seguridad
http://www.microsoft.com/spain/tech...9-USER.asp
==
"Fernando España" escribió en el mensaje
news:%
Maximum Capacity Specifications
The first table specifies maximum capacities that are the same for all
editions of Microsoft® SQL ServerT 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 Microsoft® SQL Server 2000T


Windows®
CE Edition.

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 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
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
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 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 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 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 Maximum Size of
Index Keys.
3 The size of a database cannot exceed 2 GB when using the SQL Server 2000
Desktop Engine or the Microsoft Data Engine (MSDE) 1.0.
4 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
This table shows the number of processors that the database engine in each
SQL Server 2000 edition can support on symmetric multiprocessing (SMP)
computers.




Operating System

Enterprise Edition

Standard Edition

Personal Edition

Developer Edition

Desktop Engine

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


Maximum Amount of Physical Memory Supported by the Editions of SQL Server
2000
This table shows the maximum amount of physical memory, or RAM, that the
database engine in each SQL Server 2000 edition can support.




Operating System

Enterprise Edition

Standard Edition

Personal Edition

Developer Edition

Desktop Engine

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




Fernando España

el 95% de las instrucciones que precisan de un
CURSOR se puede hacer sin ellos y mas
Eficientemente.--

BRIGADA AINTI-CURSORES


****************************************



"andsilva" wrote in message
news:
> Saludos cordiales,
>
> me preguntaba si alguno de ustedes sabe de un limite de bases de datos
para
> un SQL Server 2000.
>
> Gracias
>
> Andres
>
>


Respuesta Responder a este mensaje
#3 Isaías
26/09/2003 - 20:44 | Informe spam
Excelente comentario Miguel

Ya me imagino abriendo mi consola de administracion (no se
cuanto se tardaria en generar la lista) con 32,727
bases !!!!!!!!!, uta !!!!, para encontrar una de ellas.

ja
email Siga el debate Respuesta Responder a este mensaje
Ads by Google
Help Hacer una preguntaRespuesta Tengo una respuesta
Search Busqueda sugerida