tempdb Disks

IT Asset Management (Cloud)

"tempdb" is the temporary database used by Microsoft SQL Server to hold temporary data.

For best performance, the tempdb data and transaction log files should be placed on physically different disks, and not on the same disks as used by the IT Asset Management database files.

tempdb files can be placed on local disks or on a SAN.

If RAID disks are used for tempdb, RAID 1 or RAID 10 should be used. Do not use RAID 5, because the relatively slow write speed will negatively impact performance, and the added reliability provided by RAID 5 is not needed.