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