Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Tempdb: Performance and Manageability

Sponsored by - IDERA

Webcast Abstract

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.

Speaker - Robert L. Davis

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.



































By submitting this data you are accepting to receive newsletters, account updates and special offers about SQL Server from MSSQLTips and our sponsors. We respect your privacy and you can unsubscribe at any time.



More SQL Server Solutions











Learn more about SQL Server tools