SQL Server Performance

List of CPU based DMVs in SQL Server 2005 - best used for hardware analysis

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 5, 2007.

  1. Anonymous New Member

    Dynamic Management Views (DMV) are very useful to get server state information to monitor the status, but not always you have to still continue in monitoring using SYSMON &amp; PROFILER that are available by default with SQL installation. The engine within SQL Server 2005 improves accuracy by using the high-resolution counters that are capable to provider further analysis. The list of DMVs I usually follow to capture hardware based information are as follows: Dynamic management views: • sys.dm_exec_query_stats...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/08/05/1262.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1262" width="1" height="1">

Share This Page