Breaking Up SQL Server Databases into Multiple Files#

File access is fundamental and an essential consideration to an OLTP system. If your system is busy (it gets a high number of transactions), or you expect it to be in the future, put in a little planning to prevent waiting for the disk. The next topics will address file placement, as well as log files and adding data.

For additional information, please refer to the following links:

• Optimizing TempDB Performance ⧉
• Capacity Planning for TempDB ⧉
• Place Data and Log Files on Separate Drives ⧉
• How to Optimally Use SSDs Without Burning Them Out ⧉