Troubleshooting TempDb

For the most DBAs and DEVs the TempDb is a crystal ball. But the TempDb is the most critical component in a SQL Server installation and is used by your applications and also internally by SQL Server. TempDb is also one of the performance bottlenecks by design, because it is shared across the whole SQL Server instance. In this session we will take a closer look into the TempDb, how it is used by SQL Server, and how you can troubleshoot performance problems inside TempDb and how you can resolve them.
Presented by Klaus Aschenbrenner at SQLBits X
  • Downloads
  • SpeakerBIO
    Klaus Aschenbrenner provides SQL Server Consulting services across Europe and the US. He helps people around the world to understand, use, and run SQL Server installations in their environments. In the years 2004 - 2005 Klaus was honored with MVP awards from Microsoft for his tremendous support of the .NET Community. Klaus is also the author of the book Pro SQL Server 2008 Service Broker (ISBN 1590599993) published by Apress in August 2008.
  • Video