PASS Summit 2010
Register Now

ROI Justification



PASS Facebook PASS LinkedIn PASS Twitter

Premier Sponsor:

Platinum Sponsor:
How to Optimize tempdb Performance
DBAs often don’t spend a lot of time watching tempdb performance. They think of it as a black box that takes care of itself. What many DBAs don’t fully realize is how tempdb performance can affect SQL Server’s overall performance. This is especially true in SQL Server 2005 and SQL Server 2008, which use tempdb much more than previous versions.

In this session you will learn: What Objects are Stored in tempdb; How tempdb Works Internally; Different Types of tempdb Problems; How to Monitor tempdb; and Ways to Optimize tempdb Performance.

This session is targeted towards those DBAs who want to learn how tempdb works, and how to optimize its performance. It is assumed that attendees have a basic foundation of DBA knowledge. After attending the session, attendees will be able to return to work and immediately put what they have learned into practice.
Red Gate Software
Director of DBA Education
Brad M. McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelor’s degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP with over 15 years SQL Server experience, over 6 years training experience, and has been involved in the industry since 1982. Brad is a frequent speaker at SQL PASS, European PASS, SQL Connections, SQLTeach, devLINK, SQLBits, SQL Saturdays, TechFests, Code Camps, SQL Server user groups, and other industry seminars, where he shares his 15 years’ cumulative knowledge. In 2009, Brad made 33 public presentations to a total of 1,853 attendees, in six different countries. Brad was the founder of the popular community site SQL-Server-Performance.Com, and operated it from 2000 through 2006, where he wrote over one million words on SQL Server topics. A well-respected and trusted name in SQL Server literature, Brad is the author or co-author of more than 15 technical books and over 250 published articles. His most recent books include How to Become an Exceptional DBA (2nd Edition), Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs, Mastering SQL Server Profiler, and Brad’s Sure Guide to SQL Server Maintenance Plans. He blogs at
Register Now for PASS Summit 2010!

  Top Reasons to Attend
PASS Summit 2010
  • Over 160 technical sessions from the world's top SQL Server and BI experts
  • 2 full days of deep-dive Pre- and Post-Conference Seminars
  • Networking with thousands of SQL Server MVPs, experts, Microsoft employees, and peers
  • Face-to-face support with the Microsoft CSS and SQLCAT teams
  • Ask the Experts Lounge
  • And much more!

Gold Sponsor

Copyright 2010 by PASS | Terms of Use | Privacy Statement