SQL Server Performance

SQL Server DMVs - where to start and how to use?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Sep 12, 2010.

  1. Anonymous New Member

    When you need to troubleshoot a problem, prior to SQL Server 2005 you have to depend upon PROFILER or query system tables constantly or some other means to trace the system usage. SQL Server 2005 onwards DBAs are equipped with Dynamic Management Views (and Data Mining Extenstions DMX for Analysis Services) for core database engine to obtain the snapshot of information on resource usage such as disk, cpu, memory and many more. The 2 types of DMVs are server-scoped &amp; database scoped whics requires...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2010/09/13/sql-server-dmvs-where-to-start-and-how-to-use.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9542" width="1" height="1">

Share This Page