SQL Training

SQL Saturday #203 Pre-Seminar: No More Guessing! with Adam Machanic

Scratching your head, you stare at the screen. Should you rebuild an index? Create a new one? Reboot the server? Why is this query so slow?!? Figuring out performance problems can sometimes feel like fumbling your way through a dark room. Maybe you’ll get lucky and find the right solution―or maybe you’ll stub your toe. Either way, it’s a slow, potentially painful process. Yet finding the root cause of most performance issues is a simple exercise, once you understand where to look and when.

In this full day seminar, a proven methodology will be illustrated through complete demonstrations that will teach you how to drill from high-level problem detection all the way to a specific spot in a query plan or deeper―pinpointing the exact problem and helping you to quickly solve it. Attend this seminar to take full control of your databases—and never again stumble blindly through the dimly lit world of performance troubleshooting.

Courseware booklets, lunch, and morning/afternoon coffee included.



Instructor: Adam Machanic

Dates: TBD

Location: Your City?

Course Detail PDF Download of: SQL Saturday #203 Pre-Seminar: No More Guessing! with Adam Machanic

Download the course details for yourself or your employer!

Module 1: Baselining Methodology

  • What is a baseline, and why should you care?
  • How do you create meaningful benchmarks?
  • How should you collect baseline data?
  • What kinds of testing should be done?

Module 2: Performance Counters

  • Which counters, specifically, should you look at?
  • What, exactly, do all of these counters actually indicate?
  • How should you analyze counter data?
  • How should you not analyze counter data?

Module 3: Waits and Queues

  • What is a wait? What is a queue? Why should you care?
  • How do you collect the waits data that SQL Server exposes?
  • How do you baseline wait stat information?
  • What are the most important wait stats to pay attention to, and what do they actually indicate?

Module 4: Real-Time Activity DMVs

  • How do you get more pointed and in-depth information about what’s happening in your SQL Server instance?
  • Why are there so many DMVs? Which ones are actually important to understand?
  • How do you baseline some of the data from the DMVs?
  • What information will help you solve real problems, in your real SQL Server instances, when those problems are actually occurring?

Module 5: Query Plan Analysis

  • What are the top 5 things that you can quickly look for to identify problems with query plans?
  • How can you understand when and why plan regressions occur?

Intended Audience

Database professionals, including both DBAs and developers, who are interested in learning how to attain better SQL Server performance.


At least two years of experience is recommended.

What You Will Learn

In this full day seminar, you will learn a proven methodology that can be used to approach virtually any performance problem. Created and refined by Adam Machanic over several years, this strategy leverages core SQL Server performance tools (including dynamic management views, Extended Events, and WMI counters), applying them to various performance troubleshooting techniques (such as waits and queues analysis, baselining, and real-time activity monitoring). Each of these tools and techniques has a unique role, and you will learn to use them cooperatively to quickly and adaptively find the actual cause of performance issues.

Instructor Bio:

Adam Machanic

Adam Machanic is a Boston-based database consultant, writer, and speaker, as well as the founder of Data Education. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications.

Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including SQL Server 2008 Internals (Microsoft Press, 2009) and Expert SQL Server 2005 Development (Apress, 2007).

Address: Your City?
Get Directions

Registration: TBD Click here to request this course

Visa, MasterCard, Discover, American Express, PayPal, eCheck, Check, Purchase Order

Data Educaiton accepts Visa, MasterCard, Discover, American Express, PayPal, eCheck, personal & business checks and purchase orders.

Course Dates: TBD (1 Day)
Course Time: 9:00 AM to 4:30 PM
Course Detail PDF Download of: SQL Saturday #203 Pre-Seminar: No More Guessing! with Adam Machanic Download the full course details in a convenient PDF

Using a Purchase Order or Check?

If a purchase order is required for invoice, please send us the P.O. number using our contact form. Be sure to indicate the course title and attendee name(s) in your message.

We accept personal and business checks for course registrations up to 15 business days before the start date of the desired course. If paying by check, remember that it can take up to 5 business days to arrive at our office through postal mail depending on your location. Please include a note telling us the course title and attendee name(s), and make your check payable to:

Data Education
15 Lincoln Street
Suite 226
Wakefield, MA 01880

Refund & Cancellation Policy

If Data Education cancels the course, you will receive a 100% refund. Registration is fully transferable to a course of the same or lesser value within one year’s time of the initial course. If you cancel your registration with more than 30 days notice, Data Education will refund the fee minus $35 for processing. If you cancel your registration with between 16 and 30 days notice, Data Education will refund 75% of the fee. If you cancel your registration with between 7 and 15 days notice, Data Education will refund 50% of the fee. Cancellations unfortunately will not be allowed as of 6 days before the beginning of the course.