The DMVs; newly introduced in SQL Server 2005 gives the database administrator information about the current state of the SQL Server machine. These values will help the administrator to diagnose problems and tune the server for optimal performance.
For more information you can refer- http://www.codeproject.com/Articles/16861/Dynamic-Management-Views-DMV-A-SQL-Server-2005-Fea
Hai, friends anybody explain the different types of BACKUPs available in SQL Server 2005