SQL Server database with 100 terabyte of data

1 vote

2 answers

773 views

performance sql-server-2019 performance-tuning enterprise-edition big-data

                          We have been assigned a new application where the vendor is expecting the database to grow to around 100 TB. They have mentioned SQL Server Standard Edition is compatible. 

My question is whether SQL Server Standard Edition can adequately handle a database of that size? 

The Enterprise Edition can handle online index rebuild, but overall can SQL Server can handle such big database?

The biggest database I have managed is 3 TB and I am worried how a 100 TB database will perform with SQL Server 2019.

Any advises from experts will be greatly appreciated.

Asked by SQL_NoExpert (1117 rep)

Sep 28, 2023, 02:54 PM
Last activity: Sep 29, 2023, 10:03 AM

SQL Server database with 100 terabyte of data

Related Questions