The TempDB Database

The TempDB database is a SQL Server system database that comes with every installation of SQL Server. The database is recreated newly every time the SQL Server service begins execution.

The TempDB is best described as SQL Server's "scratchpad" for storing temporary data. It is an often neglected and overlooked system component that significantly affects overall server performance. How it is configured, its RAID selection, its data and log file sizes, and how they are distributed on disks, all affect server performance.

I am an expert on the optimum configuration of every detail related to the TempDB database. If it is configured incorrectly, I can advise you of the recommended changes and implement them to improve your server’s performance, especially when executing long running queries/reports.

Contact me to schedule a free consultation on performance tuning your SQL Server.