top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are DMVs in context of SQL Server?

+5 votes
360 views
What are DMVs in context of SQL Server?
posted Nov 18, 2013 by Atul Mishra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+2 votes

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

answer Nov 20, 2013 by Neeraj Pandey
...