What do you understand by DVMs in SQL Server?

The DMVs were introduced in SQL 2005, DMVs allow you to get better insight into what is happening in SQL Server.  Without these new tools a lot of the information was unavailable or very difficult to obtain.

Here are some of the more useful DMVs that you should familiarize yourself with:

• sys.dm_exec_sessions - Sessions in SQL Server
• sys.dm_exec_cached_plans - Cached query plans available to SQL Server
• sys.dm_exec_connections - Connections to SQL Server