Developer's Guide to SQL Server Performance

  • Instructor(s): Brent Ozar, Jeremiah Peschka, Jes Borland, 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. You get 18 months of access to the recordings streamed to your desktop/laptop/iPhone/iPad, plus 3 more bonus training videos on scalability, all for just $299. Buy it now.

Buy SQL Server Training Now

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 SQL Server Training Now

Brent-130x170

About Brent

Specialities: performance tuning, SAN storage, VMware

Off duty: foodie restaurants, travel, bad pop music

   
Jeremiah-130x170

About Jeremiah

Specialities: database architecture, teaching SQL, cloud computing

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

  

Jes-130x170

About Jes

Specialities: automation, performance tuning, high availability

Off duty: punk rock, running, community-building

 
Kendra-130x170

About Kendra

Specialities: query tuning, index rocket science, SSDs

Off duty: drawings, dinosaurs, Spurious Capitalization

 

Suggested Courses

Performance Bundle: Buy Two, Get One Free

  • Length: 20+ Hours of Videos
  • Cost: $598 (Save $299)
You want to master SQL Server performance tuning - from wait stats to interpreting execution plans to index tuning. You want in-depth material that you can refer back to over and over. This is the all-in-one resource for you.

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.

css.php