Part 1: Configuring Profiler and Performance Monitor

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

ID Task Directions and/or screenshot
1 Time period

Select a time period when you suspect SQL Server performance issues are occurring, when you are able to run Profiler

and Performance Monitor at the same time. Keep in mind that running both will consume a lot of resources.

2 Profiler: Configure and save the Profiler trace data to a table or file and be sure to capture both the start and end-time values for SQL Server 2005 Profiler. Reference the SQL Profiler: Features, functions and setup in SQL Server 2005 tip for instructions on how to set Profiler.
3a Performance Monitor: Configure and save the Performance Monitor Counter Log and save the results to a log in the format of a comma-delimited text file.

Open Performance Monitor by pressing 'CTRL + R' and typing 'perfmon.'

Once Performance Monitor loads, click on the 'Counter Logs' on the left pane and the screen should look like the one on the right.

3b General Tab: Right click in the right pane and select 'New Log Settings…'

Give the trace a meaningful name that will be easily recognizable to you.

On the 'General' tab, click on the 'Add Objects' button to launch the 'Add Objects' interface in 3c.

Also, remember where the log file is saved to reference in your upcoming analysis.

3c Add Objects: From the General tab, click "Add Objects." Then scroll down the list of performance objects, highlight those needed, click the 'Add' button once you select all the performance objects, and then press the 'Close' button to save the configuration.

3d Log Files Tab: On this tab, select the 'Log file type' as 'Text File (Comma delimited).'

3e Schedule Tab: On this tab, configure the schedule parameters.

Press the OK button to start the data capture.



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

  • 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

    Pro+

    Features

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

    0 comments

    Oldest 

    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:

    SearchBusinessAnalytics

    SearchDataCenter

    SearchDataManagement

    SearchAWS

    SearchOracle

    SearchContentManagement

    SearchWindowsServer

    Close