In my survey this week I'd like to find out how large the largest single SQL Server database is at your company (how much space does the data take up on disk, roughly). I ran a similar survey almost two years ago and I think it will be interesting to compare the results.
[Edit: the survey is closed now.]
I'll report on the results next week. If you answer with a database size more than 20TB, I'd be really interested to know the size so I can tell people – completely anonymously of course. Leave a comment if you want.
PS Don't forget the early-bird registration for our March performance tuning class in Dallas ends this Friday!
7 thoughts on “Survey: what’s the largest SQL Server database at your company?”
5 to 20 TB. But we are in the process of trimming down and rolling up historical data. Large datasets are not easy to manage for DR and Cloud Backup.
Our biggest single database is ~25 TB. And that’s with everything page compressed.
Sir,I believe with such huge numbers already listed in the poll result(still running),the great big databases will surely be among data-warehouse.OLTP performance and DR risk will increase with such huge sizes.For OLTP,I have worked on a 700GB database.Do you think an OLTP can go in TBs without compromising on performance and administrative efforts?
I see more people using filestream to store BLOBs > 1 Mbytes and reducing databases Size
Our biggest is greater than 1 TB and it is OLTP database. That same SQL Server instance holds another 2.5 TB of data in other database as well.
31 TB so far. But we are implementing a new database to handle about 50 TB with sliding window partition.
Our Biggest Database size is 9 TB