What size of SQL Database is classified as a Large Database?

Question

I have a Database of 1.6 terabytes and I am beginning to get worried about performance issues in the future, if growth is not controlled. I am looking at splitting data files into multiple files and creating new file groups as well to partition tables into, but should I really worry because of the size?

Answer 1

You must check your queries and indexes performance. According to the performance metrics you can decide. 1.6 TB database size for one database, for one data file is actually large. If you use partitioning , you can manage easier and get performance gains

Answer 2

If you have a good performing SAN, at best a SSD-SAN, and enough RAM on the machine, then I wouldn't worry about 2 TB database size.

Monitor the system to see, if CPU or memory preasure occurs.

Answer 3

Hi @Babawale Dawodu,

There are several things that can be done to improve performance such as tuning code to implementing better physical resources such as memory, computing power, and storage. One of the primary bottlenecks for database systems is the lack of sufficient storage throughput and because database applications rely heavily on storage, a poorly implemented storage strategy can quickly become a problem.

Details you may check below.

Strategies to Improve SQL Server Storage Performance

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.