Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
SQL Server

How we can use Dynamic Management Views(DMV) using Sql Server 2005

Author: Zunnair

In This Article I will explain the way in which we can use DMV (Dynamic Management Views).

DMV Relates to many Issues and it can give us their current statuses before last restart of sql Server 2005. Before Sql Server 2005 there is no concept of Dynamic Management Views and user cannot identify that its table indexes are properly set or not are they Clustered or non Clustered.

It has been always a challenge for database administrators to figure out which indexes on a table are helpful and which aren't. In SQL Server 2005, Microsoft introduced Dynamic Management Views (DMV) which return server state information that can be used by developers or database administrators to monitor the health of a SQL Server Instance and identify potential performance issues. Dynamic Management Views basically reflect all the activities on the instance of SQL Server since the last restart of SQL Server. All the Dynamic Management Views exist in the SYS schema and they can be easily identify as they follow the naming convention of dm_*.


SELECT * FROM sys.sysobjects WHERE NAME LIKE 'dm_%'


Try to use these things if you use them in your daily routine it will beneficial for u.I hope this article is helpful for you in understanding of DMVs.

Add Article Comment:
Name :
Email Address :
Comments :
<< Creating Cursor using PL-Sql in Sql Server 2008

Disclaimer - Privacy
© 2002-2017