Problem solve Get help with specific problems with your technologies, process and projects.

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
  • Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

    Start the conversation

    Send me notifications when other members comment.

    Please create a username to comment.