Move TempDB for Performance – SQL in Sixty Seconds #107


Just another day while working with a client Comprehensive Database Performance Health Check, we figured out that they had slow overall performance because they had TempDB located on the slow drive. Today we will learn how we can move TempDB for Performance.

Before I continue I must say that you only need to do this if your TempDB on the drive which is slow. Additionally, when you install SQL Server by default and do not customize it, it is quite possible that your TempDB is located on the same drive where your Operating System is installed. It is never a good