Its all about numbers – Some capacity specifications within SQL Server !


Recently I was doing a pretty large SQL 2012 deployment, and was doing some research on capacity specifications.

There were lot of numbers which I found really interesting and some were really new to me. I thought it would be worth sharing them.

Maximum Database Size  - 524,272 terabytes (Both 32bit and 64bit)

Databases Per Instance – 32,767 (Both 32bit and 64bit)

File Groups Per Database – 32,767 (Both 32bit and 64bit)

Files Per Database - 32,767 (Both 32bit and 64bit)

File Size Data  - 16 TB (Both 32bit and 64bit)

File Size Log  - 2 TB (Both 32bit and 64bit)

Instances Failover Cluster  - 25 instances on a failover cluster when using a shared cluster disk as the stored option (Both 32bit and 64bit)

Nonclustered indexes per table  - 999 (Both 32bit and 64bit)

Parameters per stored procedure  - 2100 (Both 32bit and 64bit)

Parameters per user-defined function - - 2100 (Both 32bit and 64bit)

Partitions per partitioned table or index  - 15,000 (Both 32bit and 64bit)

XML indexes - 249  (Both 32bit and 64bit)

Columns per SELECT statement - 4,096 (Both 32bit and 64bit)

Columns per INSERT statement - 4,096 (Both 32bit and 64bit)

There are lot many numbers which might surprise you and the complete list is available here.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s