Languages: T-SQL, PL/SQL, C#, C, C++, Java, UNIX shell scripts, XML, HTMLĭatabases: MS SQL Server 2012/2008/2005/2000, Oracle 8i/9i and 10g, DB2, MS Access, Nettezza.ĮTL Tools: DTS, SSIS, Informatica, Power Center 6.2/7.1.x/8.1.1/8.6.1,DataStage 6.0
The most frequently used DMV sections are: Get all the DMVs using the following queries: These values will help administrators to identify problems that cannot be caught in the SQL Server Profiler or Performance Monitor. This provides the current information about the procedures of the service and the server health.
This article explains Dynamic Management Views (DMVs) in SQL Server 2008 R2.