SQLBits 2018

Investigate TempDB like Sherlock Holmes

Learn how to investigate the mysterious case of SQL Server performance problems in TempDB.
The system database TempDB has often been called a dumping ground, even the public toilet of SQL Server. (There has to be a joke about spills in there somewhere). In this session, you will learn to find those criminal activities that are going on deep in the depths of SQL Server that are causing performance issues. Not just for one session, but those that affect everybody on that instance. 
After this session, you will have learned how to architect TempDB for better performance, how to create code more efficiently for TempDB, understand how space is utilized within TempDB,  and have learned about queries and counters that will help diagnose where your bottlenecks are coming from.