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

This story continues at http://www.databasejournal.com/news/article.php/3711756