select * from sys.system_views

select * from sys.system_views where name like 'dm%' order by name

dm_audit_actions

dm_audit_class_type_map

dm_broker_activated_tasks

dm_broker_connections

dm_broker_forwarded_messages

dm_broker_queue_monitors

dm_cdc_errors

dm_cdc_log_scan_sessions

dm_clr_appdomains

dm_clr_loaded_assemblies

dm_clr_properties

dm_clr_tasks

dm_cryptographic_provider_properties

dm_database_encryption_keys

dm_db_file_space_usage

dm_db_index_usage_stats

dm_db_mirroring_auto_page_repair

dm_db_mirroring_connections

dm_db_mirroring_past_actions

dm_db_missing_index_details

dm_db_missing_index_group_stats

dm_db_missing_index_groups

dm_db_partition_stats

dm_db_persisted_sku_features

dm_db_script_level

dm_db_session_space_usage

dm_db_task_space_usage

dm_exec_background_job_queue

dm_exec_background_job_queue_stats

dm_exec_cached_plans

dm_exec_connections

dm_exec_procedure_stats

dm_exec_query_memory_grants

dm_exec_query_optimizer_info

dm_exec_query_resource_semaphores

dm_exec_query_stats

dm_exec_query_transformation_stats

dm_exec_requests

dm_exec_sessions

dm_exec_trigger_stats

dm_filestream_file_io_handles

dm_filestream_file_io_requests

dm_fts_active_catalogs

dm_fts_fdhosts

dm_fts_index_population

dm_fts_memory_buffers

dm_fts_memory_pools

dm_fts_outstanding_batches

dm_fts_population_ranges

dm_io_backup_tapes

dm_io_cluster_shared_drives

dm_io_pending_io_requests

dm_os_buffer_descriptors

dm_os_child_instances

dm_os_cluster_nodes

dm_os_dispatcher_pools

dm_os_dispatchers

dm_os_hosts

dm_os_latch_stats

dm_os_loaded_modules

dm_os_memory_allocations

dm_os_memory_brokers

dm_os_memory_cache_clock_hands

dm_os_memory_cache_counters

dm_os_memory_cache_entries

dm_os_memory_cache_hash_tables

dm_os_memory_clerks

dm_os_memory_node_access_stats

dm_os_memory_nodes

dm_os_memory_objects

dm_os_memory_pools

dm_os_nodes

dm_os_performance_counters

dm_os_process_memory

dm_os_ring_buffers

dm_os_schedulers

dm_os_spinlock_stats

dm_os_stacks

dm_os_sublatches

dm_os_sys_info

dm_os_sys_memory

dm_os_tasks

dm_os_threads

dm_os_virtual_address_dump

dm_os_wait_stats

dm_os_waiting_tasks

dm_os_windows_info

dm_os_worker_local_storage

dm_os_workers

dm_qn_subscriptions

dm_repl_articles

dm_repl_schemas

dm_repl_tranhash

dm_repl_traninfo

dm_resource_governor_configuration

dm_resource_governor_resource_pools

dm_resource_governor_workload_groups

dm_server_audit_status

dm_server_memory_dumps

dm_server_registry

dm_server_services

dm_tran_active_snapshot_database_transactions

dm_tran_active_transactions

dm_tran_commit_table

dm_tran_current_snapshot

dm_tran_current_transaction

dm_tran_database_transactions

dm_tran_locks

dm_tran_session_transactions

dm_tran_top_version_generators

dm_tran_transactions_snapshot

dm_tran_version_store

dm_xe_map_values

dm_xe_object_columns

dm_xe_objects

dm_xe_packages

dm_xe_session_event_actions

dm_xe_session_events

dm_xe_session_object_columns

dm_xe_session_targets

dm_xe_sessions

select * from sys.dm_tran_locks