Richard Douglas is a Senior Solutions Engineer at SentryOne, where he specializes in the SQL Server product range. He has worked with SQL Server since version 7.0 in various developer and DBA roles and holds a number of Microsoft certifications. Richard is a keen member of the SQL Server community, he ran a PASS Chapter in the UK, served on the organizing committee for SQLRelay, and has spoken at a number of events across EMEA and the US. Richard blogs at http://SQL.RichardDouglas.co.uk and on http://Blogs.Sentryone.com. Richard is also on Twitter as @SQLRich.
Investigate TempDb Like Sherlock Holmes
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.