What are Dynamic Management Views in SQL Server? Part - 2

6. DMVs for system information

It may be recognized by the prefix "sys.dm_os_"

Examples are sys.dm_os_wait_stats and sys.dm_os_memory_clerks.

7. DMVs with High Availability

Using the prefix "sys.dm_hadr_"

Examples are sys.dm_hadr_database_replica_states and availability_replica_states.

8. DMVs for Extended Events:

Using the prefix "sys.dm_xe_"

Examples are sys.dm_xe_sessions and sys.dm_xe_database_session_events.

9. DMVs for CLR Integration:

It may be recognized by the prefix "sys.dm_clr_"

Examples are sys.dm_clr_appdomains and sys.dm_clr_properties.

10. DMVs for filestreams:

The prefix "sys.dm_filestream_" serves as an identifier.

Examples include sys.dm_filestream_non_transacted_handles and sys.dm_filestream_file_io_handles.

What are Dynamic Management Views in SQL Server? Part - 1

What are Dynamic Management Views in SQL Server? Part - 3

What are Dynamic Management Views in SQL Server? Part - 4