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

SQL Server 2005 guide to performance metrics

SQL Server 2005 allows you to map micro-level data to macro-level metrics by associating SQL Profiler and Performance Monitor in one interface. Edgewood Solutions' Jeremy Kadlec explains how to do this.

SQL Server 2005 Profiler allows you to associate Profiler data and Performance Monitor metrics in one interface. Profiler is the native SQL Server tool used to capture SQL Server transaction performance metrics. Performance Monitor is the native tool to capture macro-level SQL Server and Windows metrics. One major performance-tuning challenge has been to determine the affect of a single SQL Server transaction or set of SQL Server transactions on overall Windows metrics (i.e., processor, memory, I/O) for the entire server.

So why would I want to associate these two pieces of data? This new capability in SQL Server 2005 Profiler gives DBAs and developers the ability to map micro-level data to macro-level metrics when performance tuning. This correlation helps better interpret performance metrics' data and, figuratively speaking, drill down from the metric to the SQL Server transactions and vice versa.

In this step-by-step guide, I'll explain how to associate Profiler and Performance Monitor data.

 


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 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.

 

More information from SearchSQLServer.com

 

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.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close