Perfmon and Profiler for SQL Server

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

4 Comments. Leave new

  • Hey Brent

    This a Univ student trying to learn SQL Server on my own. I was wondering if the Perform has changed over time(windows xp to Windows 7)Im on W7 machine n dont find any resemblance to the steps u talked about while trying to create log counters.
    Am i looking at wrong place.?
    I am looking at what s called “Performance Monitor”

    Any Ignorance to be excused.

  • My first thought to your quiz was to serialize the reports, can I have a drink ticket?