We recently created some new database servers (VMs), moving content to them from old servers approaching end of life.
Our standard was to create a drive for the application (SQL) another for the operating system. We have a few production databases on them and everything appears to be working properly.
Later realized one mistake right away - not creating a separate drive for TempDB. I'm going to address that shortly, that appears to be pretty straight forward.
Further review suggests setting at least a separate drive for ldfs as well.
Any other suggestions / URLs would be appreciated. Thanks.
Tempdb data files and log files should ideally be separated and stored away from user database data and log files.
If you cannot separate the tempdb data and log files put them on the same drive together
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉