Step-by-Step Guide

Part 2: Capturing data in SQL Profiler and Performance Monitor

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.


    Requires Free Membership to View


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

ABOUT THE AUTHOR:   
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 SearchSQLServer.com Performance Tuning expert. Ask him a question here.
Copyright 2006 TechTarget

More information from SearchSQLServer.com

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

    There are Comments. Add yours.

     
    TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

    REGISTER or login:

    Forgot Password?
    By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
    Sort by: OldestNewest

    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: