Aug 212012
 

As some of you know, I am actively pursuing Microsoft Certified Master status for SQL Server 2008. Last week I attended the SQLskills Immersion Event on Performance Tuning (IE2) in Bellevue, WA in the continued path to this goal.

Wow. I thought IE1 was fantastic… IE2 was exactly what I needed.

The core outline for the class is as follows:

  • SQL Server IO
  • IO Concepts
  • SANs for DBAs
  • SQL OS
  • Waits and Queues
  • Extended Events
  • Query Plan Analysis
  • CPU Performance Tuning
  • Plan Cache and Index Analysis
  • Memory Performance Tuning
  • Benchmarking and Baselining
  • Collecting Performance Data

Glenn Berry even sat in for an impromptu session on hardware for the DBA, which was fantastic as well!

Everything I learned directly contributes to not only my quest for the MCM title, but complements everything that I do at the day job. The SQLskills Immersion events are hands-down the best SQL Server training that you can get, period. I had a blast, and I’ll be back for IE3 – High Availability & Disaster Recovery next year sometime!

 Posted by at 4:22 am