2
kudos
spam Kudos Remove

SQL Server DMVs - where to start and how to use?
published 607 days, 16 hours, 16 minutes ago posted by sasa 616 days, 17 hours, 43 minutes ago
Wednesday, September 22, 2010 7:05:59 PM GMT Monday, September 13, 2010 5:38:28 PM GMT
SQL Server DMVs - where to start and how to use?
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 & database scoped whics requires...(read more)
category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code
tags: beginner, Best Practices, DBA, disk space, DMV, Memory, Performance, performance tuning, resource, SQL Server, system, troubleshoot

No comments yet, be the first one to post comment.

To post your comment please login or signup