How-to : Collecting performance counters and using SQL Server to analyze the data…

Quite frequently I find myself in situation where I need to get detailed information on performance monitor counters. For example I need to determine which processes are consuming all CPU at certain times. I find it handy to push the performance monitor counters into SQL Server where I can query it or perhaps display it in Reporting Services.

The following will explain how to select counters, how to collect data, how to load the data to SQL Server and how to query the data that has been saved. _us


Comments (0)

Skip to main content