Perfmon and Profiler for SQL Server

Performance Monitor and SQL Server Profiler are the key to getting started with performance tuning.  I’ll show you how to get started with these tools, how to slice and dice the results, and even how to data mine the results to look for interesting trends.  Whether you like to monitor performance with native tools or third party utilities, knowing how the native tools work will help you get better results out of your tools.

In this one-hour video recorded at the SQLBits 2009 conference, you will learn:

  • Why Perfmon is like a Nissan GT-R’s dashboard
  • What Perfmon counters to measure, and what they mean
  • Four common performance symptoms and how to cure the problems