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...
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