Geek Answers Handbook

What are the sizes of the largest SQL Server database in the world?

I am interested in what is the potential of SQL Server when it comes to the amount of data (database size, row count, etc.).

+6
database sql-server
source share
8 answers

Check out these old numbers:

Most recently, check this out: Microsoft applauds 1.1 Petabytes SQL Server 2008 Database

+6
source share

Since other answers are outdated / broken links.

Here is the answer from 2014:

Uncompressed, the Options and Equity archive is 2 petabytes (PB) in size. When compressing a page, it measures 1.5 PB.

They also claim that they add 500 TB to the database every year.

See: NASDAQ OMX Group Example

+3
source share

When sizing for performance, you cannot just look at the size of the database; you must also include so many other factors, such as how large each record is. In this 1.1 PB it is for heavenly images. These will probably be very large files. Thus, the number of entries will be very small. Although both size and number of records are important, the number of records will play a greater role in DB execution than the total size.

In the company where I worked, we had a SQL database of less than 10 TB. When we asked Microsoft to evaluate the performance, they could only compare us with their own database, because they did not know about another company with a larger SQL Server database. We were shocked and worried that we had such a large database in SQL Server compared to other Microsoft clients.

If I did this again, I would not put a high transactional system in SQL Server.

+1
source share

Perhaps a few terabytes ... but who knows ... this is usually not publicly available information (since this is a production database of real companies).

official numbers are 524272 terabytes. (for the maximum possible database size ...)

check Link for all other data and size numbers for sql (2008)

0
source share

Our production database is 1.8 TB with several tables with more than 500 million records and several tables exceeding 2 billion records. On average, we process 1000 transactions per second. It works very well.

0
source share

One of our largest databases in SQL Server 2008R2 Enterprise is 25 TB and the table size is 20 billion records, increasing by 25 million per day. We have a table divided into 1000 files. The response time is less than 20 ms. We have several database files on SAS 10K RAID 10 drives and others on RAID 5 SSDs.

0
source share

The largest SQL server database is 1.1 PB.

-one
source share

Theoretically, its infinite u just needs space, the question is space and the ability to cool these servers, they should be cool. The question you should ask is the largest server to date, it is increasing every year.

-one
source share

More articles:


All Articles