In my post about increasing your SQL Server performance with tempdb, I talked about performance tuning steps related to the tempdb system database. But of course: as proof or even part of such tuning steps, it is crucial to measure the differences between current and previous implementations. That is why I would like to highlight some useful techniques and provide you with functional insights on how to analyze tempdb I/O stalls or bottlenecks. This information is especially useful if you’re a database administrator!
The tempdb system database is a global resource that is part of the system database and available to all connected users in SQL Server. As such, the tempdb can be seen as the worksheet of SQL server. Any improvement to the system will automatically effect all your custom databases. It is therefore highly recommended to fine-tune the tempdb configuration as much as you can. In this blog post, I’d like to highlight some interesting ways or best practices on how to increase its performance!