• bobba - Tuesday, January 30, 2018 9:36 AM

    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.

    We have splitted our TempDB data, log in different drive, UserDB data & Log in different drives, Other system database in seperate drive and seperate drive for backup as well.