Part 2: Capturing data in SQL Profiler and Performance Monitor

Learn how to map micro-level data to macro-level metrics by associating SQL Profiler and Performance Monitor. This section helps you capture data in each tool.

ID Task Directions and/or screenshot
4 Performance Monitor: Validate that the recently created counter log is running by making sure the corresponding icon is green, which you can see in the Name column.

5a Time Period: Once the time period has elapsed, be sure to stop both the Profiler and Performance Monitor counters if automatic stop times were not configured.

In Profiler, you can accomplish this by pressing the red stop button in the main tool bar.

5b In Performance Monitor, this can be accomplished by highlighting the selected log and pressing the black stop button on the tool bar.

Associating SQL Profiler and Performance Monitor data

 Home: Introduction
 Part 1: Configuring Profiler and Performance Monitor
 Part 2: Capturing data
 Part 3: Associating and analyzing data

Jeremy Kadlec
Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. Jeremy is also the Performance Tuning expert. Ask him a question here.
Copyright 2006 TechTarget

More information from

  • Tip: Top 10 Performance Monitor counters
  • FAQ: SQL Server performance boosters
  • Learning Guide: SQL Server performance tuning A to Z
  • This was first published in April 2006

    Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning



    Enjoy the benefits of Pro+ membership, learn more and join.



    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to: