Tell me Some DMV names and its uses in SQL Server?

We can query dynamic management views (DMVs) via T-SQL to monitor workload performances and diagnosis performance problems, which might be caused by blocked or long running queries, resources bottleneck, suboptimal query plans, and more. 

For graphical query resource monitoring, use the Query Store feature.

The new enhanced DMVs fall into the three categories

1. Database related:

sys.dm_db_log_stats - 

sys.dm_db_log_info

sys.dm.db_stats_histogram

sys.dm_db_file_spsce_usage

sys.sys.dm_db_tuning_recomendations

2. Transaction Related:

sys.dm_db_tran_versioon_store_space_usage

3. PERFORMANCE TUNING Related:

sys.dm_exec_sessions

sys.dm_exec_connectiones

sys.dm_exec_requests

sp.whosactive

sys.dm_os_wait_stats

sys.dm_os_performance_counters

4. QUERY SPECIFIC TUNING Related:

sys.dm_exec_query_stats

sys.dm_exec_query_plan

sys.dm_exec_cached_plans

sys.dm_exec_sql_text

5. INDEX Related:

sys.dm_db_index_uses_stats

sys.dm_db_missing_index_details

6. SQL Server Operating System related

sys.dm_os_host_info

sys.dm_os_sys_info