Optimizing tempdb and temporary object use

This session will cover how and why you should configure tempdb, how to troubleshoot tempdb issues, and how to detect, resolve, and mitigate allocation contention issues by creating multiple data files, optimizing temporary object reuse, and using trace flag 1118.
Presented by Christian Bolton at SQLBits VI
Tags (no tags)
  • Downloads
    Video available WMV Video 231 MB
  • SpeakerBIO

    Christian Bolton is the Technical Director for Coeo Ltd, a leading provider of SQL Server Managed Support and Consulting in the UK and Europe. He is a Microsoft Certified Architect, Microsoft Certified Master and MVP for SQL Server, and lead author of Professional SQL Server 2012 Internals and Troubleshooting.

  • Video