Read more about the article Performance Monitor Data into SQL Server tables
Microsoft SQL Server

Performance Monitor Data into SQL Server tables

On a machine running SQL Server there are a lot of performance counters that can be used to create baselines or to investigate performance problems. Those specific to SQL Server can be sampled regularly from the system table sys.dm_os_performance_counters. But those belonging to the OS must be gathered in some other way. Since I’m a SQL Server DBA, of course I want the counters saved to a table in SQL Server 🙂

(more…)

Continue ReadingPerformance Monitor Data into SQL Server tables