SQL Server supports the maximum number of objects

Many people on the Forum asked questions about the maximum number of databases, instances, tables, and fields supported by SQL Server. There is an article on msdnArticleSpecifically introduced the capacity specifications of SQL Server, includingSQL ServerDatabase Engine objectSQL
ServerUtility object
SQL ServerData layer applicationsProgramObjectSQL ServerCopy object. Understand SQL
Server restrictions can avoid some errors. For example, if the SQL Server Index key has 16 columns, the index cannot be created if it exceeds 16.

Here, I only list the maximum size and maximum number of objects defined in the SQL Server database or referenced in the transact-SQL statement. For other users, refer to the above link.

SQL Server database engine object	Maximum size/quantity-SQL Server (32-bit)	Maximum size/quantity-SQL Server (64-bit)
Batch Size 1	65,536 * network packet size	65,536 * network packet size
Number of bytes per short string Column	8,000	8,000
Number of bytes per group by and order	8,060	8,060
2 bytes per index key	900	900
Number of bytes for each foreign key	900	900
Number of bytes per primary key	900	900
8 bytes per line	8,060	8,060
Number of bytes in the Stored Procedure Source Text	Smaller in batch size or 250 MB	Smaller in batch size or 250 MB
EachVarchar (max),Varbinary (max),XML,TextOrImageNumber of bytes in a column	2 ^ 31-1	2 ^ 31-1
EachNtextOrNvarchar (max)Number of characters in a column	2 ^ 30-1	2 ^ 30-1
Number of clustered indexes for each table	1	1
Number of columns in group by and order	Limited by the number of bytes	Limited by the number of bytes
Number of columns or expressions in a group by with cube or with rollup statement	10	10
Number of columns per index key 7	16	16
Number of columns for each foreign key	16	16
Number of columns of each primary key	16	16
Number of columns in a non-Wide Table	1,024	1,024
Number of columns in each Wide Table	30,000	30,000
Number of columns in each select statement	4,096	4,096
Number of columns in each insert statement	4096	4096
Number of connections per client	Maximum Value of the configured connection	Maximum Value of the configured connection
Database size	524,272 TB	524,272 TB
Number of databases per SQL server instance	32,767	32,767
Number of file groups per Database	32,767	32,767
Number of files in each database	32,767	32,767
File size (data)	16 TB	16 TB
File size (log)	2 TB	2 TB
Number of foreign key table references for each table 4	253	253
Identifier length (in characters)	128	128
Number of instances per computer	All SQL Server versions have 50 instances. When using a shared cluster disk as the storage option installed by your cluster, SQL Server supports 25 instances in the Failover cluster. If you select SMB file sharing as the storage option for cluster installation, 50 instances are supported on the SQL Server failover cluster. For more information, see Storage types of data files.	50 instances on the independent server. When using shared cluster disks as the storage option installed by your cluster, 25 instances are supported on the Failover cluster. If you select SMB file sharing as the storage option for cluster installation, SQL Server supports 50 instances in the Failover cluster. For more information, see Storage types of data files.
Length of the string containing the SQL statement (batch size) 1	65,536 * network packet size	65,536 * network packet size
Number of locks for each connection	Maximum number of locks per server	Maximum number of locks per server
The number of locks per SQL server instance is 5	2,147,483,647 at most	Limited by memory only
Nested stored procedure level 6	32	32
Number of nested subqueries	32	32
Nested trigger Layers	32	32
Number of non-clustered indexes for each table	999	999
Number of non-repeated expressions in the group by clause if any of the following Clauses exist: Cube, rollup, grouping sets, with cube, with Rollup	32	32
Number of grouping sets generated by operators in the group by clause	4,096	4,096
Number of parameters for each stored procedure	2,100	2,100
Number of parameters for each user-defined function	2,100	2,100
Number of references for each data table	253	253
Number of rows in each data table	Restricted by available storage space	Restricted by available storage space
3 tables per Database	Limited by the number of objects in the database	Limited by the number of objects in the database
Number of partitions of each partition table or index	1,000 Important You can create tables or indexes with more than 1,000 partitions on a 32-bit system, but this is not supported.	15,000
Number of non-index column statistics	30,000	30,000
Number of tables for each select statement	Restricted by available resources only	Restricted by available resources only
Trigger count per table: 3	Limited by the number of objects in the database	Limited by the number of objects in the database
Number of columns in each update Statement (wide table)	4096	4096
User connection	32,767	32,767
XML Index	249	249