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.
(no tags)
- Downloads
- 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 2008 Internals and Troubleshooting.
- Video
- Session Files Explorer
The network name cannot be found.