XLimits - Limitationen in Microsoft SQL Server

Nachfolgend eine Liste der Limitationen und Spezifikationen.

Merkmal	Spezifikation
Devices	256 devices per SQL Server Maximum size for each logical device is 32 gigabyte (GB) Note: The maximum total addressable storage is 8 TB (256 devices * 32 GB maximum per device).
Databases	32'767 databases The minimum database size is 1 megabyte (MB) The maximum database size is 1 terabyte (TB) Note: Each logical device can be a maximum of 32 GB and each database can have a maximum of 32 device fragments (32 GB * 32 = 1 TB).
Tables	2 billion (2'147'483'647) tables per database The maximum number of bytes per row is 1'962 (exkluding text and image columns) The maximum table size is about 1 terabyte (TB)
Columns	250 columns per table
Indexes	1 clustered index per table 249 nonclustered indexes per table A composite index can have up to 16 columns
Triggers	Maximum of 3 triggers per table - one each for INSERT, UPDATE and DELETE Triggers can have 16 levels of nesting
Stored procedures	A stored procedure can contain as many as 255 parameters and have up to 16 levels of nesting
User connections	32'767 Note: MS SQL Workstation 6.0 has the same capabilities as MS SQL Server, except that it is a single-user licensed product that supports a maximum of 15 simultaneous database connections.
Open databases	32'767
Locks	2 billion (2'147'483'647)
Open objects	2 billion (2'147'483'647)

Quelle: SQL Server Books Online, Administrator's Companion for SQL Server 6.0

Haben Sie Fragen, Anregungen oder einen Fehler entdeckt?
Kontakt zum Autor