Dynamic Management Views [DMV] – A SQL Server 2005 Feature

Hari Prasad K

Rate me:

4.94/5 (28 votes)

29 Dec 2006CPOL6 min read

212.9K

The DMVs; newly introduced in SQL Server 2005 gives database administrator information about the current state of the SQL Server machine.

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Hari Prasad K

Web Developer

United States

SUMMARY

 Working as a Database Architect in US Technology [CMMI/PCMMI Level 5 Company] - WWW.USTRI.COM
 MVP in SQL Server (2 years continuously) with MCDBA Certificationin SQL 2000
 9 years of experience in MSSQL Server
 Extensive experience in SQL Server from version 6.0 to SQL 2000
 Active participation in Microsoft Public SQL Server groups and Trivandrum user group
 Contributing articles on SQL Server for MSDN India.
 Experience in Database design, Installation, Crash / Recovery, Replication, Logshipping, 24 X 7 production support, Migration, Upgrades, Performance Tuning, DTS

Dynamic Management Views [DMV] – A SQL Server 2005 Feature

Alternatives

License

Comments and Discussions