Misconceptions and inconsistent advice on tempdb abounds. Even highly skilled DBAs cannot always agree on how to best configure tempdb. Part of the problem is that there is no single solution that can be applied to every situation.
How many files should tempdb have? Should it be on RAID 1? RAID 10? How about Solid State Drives (SSDs)? How has tempdb changed in recent releases?
This session will give you the tools to determine the optimal configuration for tempdb. Also covered is how to detect, prevent, and monitor for common tempdb performance problems.
Robert L. Davis is a SQL Server 2008 Certified Master, an experienced DBA, evangelist, speaker, writer, trainer, and consultant. He is the Principal DBA with Outerwall, Inc. and consults part-time via SQL DBA Master. He has worked with SQL Server for more than 13 years, including recent stints as a Sr. Product Consultant and Chief SQL Server Evangelist for Idera Software, Program Manager for the SQL Server Certified Master Program at Microsoft Learning, and as a production DBA at Microsoft.
To access materials please fill out the form below.