Sql-server – SQL Server Storage for multiple data files

datafilesql serverstorage

Recently, our company wants to add 4TB on the drive size for SQL Server. We have two drives now which have different size and data files. In order to make sure our SQL Server has the best performance, where should I add those space:

G: Drive: 19TB (16 Data files)
H: Drive: 3TB (3 Data files)

Should I add the space on H drive and create more data files in it?
Any suggestions?

Best Answer

My Data files are always kept in a separate drive from where the SQL install took place. Therefore, databases like master, model, msdb, and tempdb are always on one drive, while my (user) databases are on (one or more) separate drives.

This is not so much for performance reasons as it is for Disaster Recovery/Security. it is much easier to restore a SQL Instance install than it is to recover the data.

If your SQL install is on either of these drives, I would chose the opposite one. If your SQL install is on neither, then I'd probably chose to add additional space to the 19TB drive (assuming it has more free space than the 3TB drive)