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
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
- Learning Guide: SQL Server performance tuning A to Z
- Tip: Top 10 Performance Monitor counters
- FAQ: SQL Server performance boosters