Developer's Guide to SQL Server Performance

  • Instructor(s): Brent Ozar, Jeremiah Peschka, Kendra Little
  • Length: 7 hours
  • Cost: $299

You’re a developer stuck with a database server that’s not going fast enough. You’ve got a hunch that the biggest bottleneck is inside the database server somewhere, but where? In this video series, you’ll learn how to use powerful scripts to identify which queries are killing your server, what parts of the database server are holding you back, how to tackle indexing improvements, and how to identify query anti-patterns.

Make SQL Server Apps Go Faster - Live at PASS Summit 2013

Developer’s Guide to SQL Server Performance – Live at PASS Summit 2013

In 7 hours of training videos with Microsoft MVPs, you’ll learn:

  • How wait stats tell you where to focus your tuning
  • How the plan cache shows you which queries are the worst
  • How to make fast improvements by picking the right indexes
  • How to identify and fix the most common query anti-patterns

Hundreds of conference attendees have paid $395 to see this training in person – but you’re about to get it for less:

Buy it now for $299.Get 18 months streaming access.


How to Think Like the Engine: Introduction to Internals Modules:

  • How to Think Like SQL Server (39 minutes, Brent Ozar)
  • Statistics and Memory (25min, Brent Ozar)

Finding the Server’s Bottlenecks:

  • Wait Statistics (44 min, Jes Schultz Borland)

What’s Happening In My SQL Server?

  • Why sp_who2 and Activity Monitor Stink (18 min, Kendra Little)
  • Find Bad Queries with sp_WhoIsActive (22 min, Kendra Little)
  • Identify Your Biggest Problems with the Plan Cache (15 min, Kendra Little)
  • Measuring Query Impact with Extended Events (13 min, Kendra Little)

Seek and Destroy: How to Identify Index Problems

  • Find the Indexes that Need the Most Help (43 min, Kendra Little)
  • Avoid Indexing Traps and Gotchas (17 min, Kendra Little)
  • Index Okapis: Includes, Filtered Indexes, and Indexed Views (30 min, Jes Schultz Borland)

T-SQL and Data Design Antipatterns

  • T-SQL Antipatterns (29 min, Brent Ozar)
  • Data Design Anti-Patterns (23 min, Jes Schultz Borland)

Scale Up or Scale Out Modules

  • Introduction and Scaling Up (26 min, Jeremiah Peschka)
  • Scaling Out with Caching (27 min, Jeremiah Peschka)
  • Scaling Out with Database Sharding (30 min, Jeremiah Peschka)
Buy it now for $299.Get 18 months streaming access.



About Brent

Specialities: performance tuning, SAN storage, VMware

Off duty: foodie restaurants, travel, bad pop music


About Jeremiah

Specialities: database architecture, teaching SQL, cloud computing

Off duty: Portland food trucks, long walks on the beach


About Kendra

Specialities: query tuning, index rocket science, SSDs

Off duty: drawings, dinosaurs, Spurious Capitalization


Suggested Courses

How to Read SQL Server Execution Plans

  • Length: 5.5 hours
  • Cost: $299
You’re comfortable writing queries, but some of them are slow – and you need more ways to tune than just adding indexes. You’ve heard that you should read execution plans, but you don’t know where to start.

Buy it now and get started

How to Tune Indexes and Speed Up SQL Server

  • Length: 7 hours
  • Cost: $299
You want to become an expert at index tuning, but you can't find a good start-to-finish training course. Learn the basics, the gotchas, and the tricks of SQL Server indexing in 7 hours of training. You'll use interactive quizzes to test your knowledge as you learn:
  • How to create, analyze, and understand clustered and nonclustered indexes
  • When to use index includes, filtered indexes, and other special structures to speed up your queries.
  • How to use free tools to find hidden columns in your indexes
  • How to tune a workload using the SQL Server Dynamic Management Views
  • How to avoid common indexing anti-patterns that drag down your database server
  • How to find critical index changes in the Execution Plan Cache
  • How you can use data to prove that your changes improved performance

Buy it now and get started

The Fine Print: Read our “Refund and Cancellation Policy for Training Videos” here. Want to pay by check or purchase order? Download our order form spreadsheet, pick out what you want, hand it to your company's accountants, and we'll set you up when we get your check.