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.
Christian Bolton is the Technical Director for Coeo Ltd, a leading provider of SQL Server Managed Support and Consulting to organisations in the UK and Europe. Prior to this, Christian worked for 5 years as a Senior Premier Field Engineer for Microsoft UK working with some of Microsoft’s biggest customers. He is a Microsoft Certified Architect, Certified Master and MVP for SQL Server, and lead author of Professional SQL Server 2008 Internals and Troubleshooting. He works out of London and lives in the south of England with his wife and children and can be contacted through http://coeo.com.