SQL Server 2012 Data Types Part 2

 SQL Server Utility Objects

The following table specifies the maximum sizes and numbers of various objects that were tested in the SQL Server Utility.

SQL Server Utility object	Maximum sizes/numbers SQL Server (32-bit)	Maximum sizes/numbers SQL Server (64-bit)
Computers (physical computers or virtual machines) per SQL Server Utility	100	100
Instances of SQL Server per computer	5	5
Total number of instances of SQL Server per SQL Server Utility	2001	2001
User databases per instance of SQL Server, including data-tier applications	50	50
Total number of user databases per SQL Server Utility	1,000	1,000
File groups per database	1	1
Data files per file group	1	1
Log files per database	1	1
Volumes per computer	3	3

1)  The maximum number of managed instances of SQL Server supported by SQL Server Utility might vary based on the hardware configuration of the Server. For getting started information, see SQL Server Utility Features and Tasks. SQL Server utility control point is not available in every edition of SQL Server 2012. For a list of features that are supported by the editions of SQL Server, see Features Supported by the Editions of SQL Server 2012 (http://go.microsoft.com/fwlink/?linkid=232473).

SQL Server Data-tier Application Objects

The following table specifies the maximum sizes and numbers of various objects that were tested in the SQL Server data-tier applications (DAC).

SQL Server DAC object	Maximum sizes/numbers SQL Server (32-bit)	Maximum sizes/numbers SQL Server (64-bit)
Databases per DAC	1	1
Objects per DAC1	Limited by the number of objects in a database, or available memory.	Limited by the number of objects in a database, or available memory.

1) The types of objects included in the limit are users, tables, views, stored procedures, user-defined functions, user-defined data type, database roles, schemas, and user-defined table types.

Replication Objects

The following table specifies the maximum sizes and numbers of various objects defined in SQL Server Replication.

SQL Server Replication object	Maximum sizes/numbers SQL Server (32-bit)	Maximum sizes/numbers SQL Server (64-bit)
Articles (merge publication)	256	256
Articles (snapshot or transactional publication)	32,767	32,767
Columns in a table1 (merge publication)	246	246
Columns in a table2 (SQL Server snapshot or transactional publication)	1,000	1,000
Columns in a table2 (Oracle snapshot or transactional publication)	995	995
Bytes for a column used in a row filter (merge publication)	1,024	1,024
Bytes for a column used in a row filter (snapshot or transactional publication)	8,000	8,000

1) If row tracking is used for conflict detection (the default), the base table can include a maximum of 1,024 columns, but columns must be filtered from the article so that a maximum of 246 columns is published. If column tracking is used, the base table can include a maximum of 246 columns.

2) The base table can include the maximum number of columns allowable in the publication database (1,024 for SQL Server), but columns must be filtered from the article if they exceed the maximum specified for the publication type.