SQL SERVER – What is the Maximum Relational Database Size Supported by Single Instance?

I often get asked following question?

“How much data SQL Server can handle?”

Every single time when I get this question – I ask back following question -

“How much data your storage system can handle?”

The reason I ask this question back is because in reality for enterprise systems the limitation of storage is no more an issue. The Matter of the fact most of the database is now a days limited by the size of the storage system. SQL Server is enterprise system and it is very mature product.

Even though if you still want to know what is the actual limit here is the answer.

SQL Server 2008R2, 2012 and 2014 have maximum capacity of 524 PB (Petabyte) in the Enterprise, BI and Standard edition. SQL Server Express has a limitation of 10 GB due to its nature. I guess, now when you look at my question it will make sense that it is all depending on the size of your storage system.

I personally believe at this point of time 524 PB is quite a huge data, but we never know after 10 years when we read this blog post, we all may think what was I thinking actually.

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

7 thoughts on “SQL SERVER – What is the Maximum Relational Database Size Supported by Single Instance?

  1. hi sir
    i joined as a fresher ..present i need to be work on MS-BI(mainly ssas ).
    please can u give plural sight on demand learning subscription on Analysis services fundamentals?

    Like

  2. Hi Pinal.
    This is a good answer but I think that it will be more useful to know how the performance is affected by the size of the DB. Im doing a research before to start designing and I’m planning to have 300Gb DBs and bigger. I’ve read (here http://voices.yahoo.com/oracle-vs-microsoft-sql-server-why-oracle-preferred-6893930.html) that the performance goes down after a couple of hudresds of gigabytes.
    Any suugestions, materials, articles to read will be welcomed.
    Thanks!

    Like

  3. Hi Pinal,
    This is good answer. please give solution of another question. can i define space for a table of sql server 2008 r2,
    Thanks,

    Like

  4. Hi,

    I wanted to develop a local intranet application where the back end is SQL SERVER DEVELOPMENT EDITION. And this application is keeping all the internal employee’s data. In every week new data will be saved into the database. So here I would like to know one thing that what is the maximum data that SQL SERVER DEVELOPMENT EDITION can support. This application I will deploy in my laptop . So is this storage is dependent on my hard disk size of my laptop.

    I am very new in the field of database storage and all.

    Can any one help on this with your valuable suggestions .

    Your timely help is well appreciated.

    Thanks in advance.

    Like

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