When designing SQL Server 2012 deployment , one should keep in mind the capacity constraints of SQL Server Database Engine.
1. Maximum size of database : 524,272 TB
2. Maximum size of single file : 16 TB
3. Maximum number of databases that can be hosted : 32,767
4. Maximum number of columns involved in a primary key : 16
5. Maximum number of foreign key references : 253
6. Maximum number of user connections : 32,767
1. Maximum size of database : 524,272 TB
2. Maximum size of single file : 16 TB
3. Maximum number of databases that can be hosted : 32,767
4. Maximum number of columns involved in a primary key : 16
5. Maximum number of foreign key references : 253
6. Maximum number of user connections : 32,767
