The "sys.dm_os_performance_counters" Dynamic Management View

Friday Nov 16th 2007 by DatabaseJournal.com Staff
Share:

SQL Server performance can be tracked and monitored by using performance counters. For SQL Server 2005, performance counters can be displayed by using the “sys.os_exec_performance_counters” Dynamic Management View (DMV).

[From SQLServer Performance]

SQL Server 2005 performance can be tracked and monitored by using performance counters. The performance counters can be displayed by either the System Monitor (PERFMON) tool, or by using the “sys.os_exec_performance_counters” Dynamic Management View (DMV). This DMV is new with SQL Server 2005. This article will explore the different counters exposed by this DMV and how you can use this DMV to monitor various performance aspects of SQL Server.

The article continues at http://sql-server-performance.com/articles/per/sys_dm_os_performance_counters_p1.aspx

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved