1. 查看系统视图的sql语句

select * from sys.system_views

2. 查看所有的 dynamic management 视图的sql

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

3. 动态视图列表(SQLSERVER 2008R2 )

dm_audit_actionsdm_audit_class_type_mapdm_broker_activated_tasksdm_broker_connectionsdm_broker_forwarded_messagesdm_broker_queue_monitorsdm_cdc_errorsdm_cdc_log_scan_sessionsdm_clr_appdomainsdm_clr_loaded_assembliesdm_clr_propertiesdm_clr_tasksdm_cryptographic_provider_propertiesdm_database_encryption_keysdm_db_file_space_usagedm_db_index_usage_statsdm_db_mirroring_auto_page_repairdm_db_mirroring_connectionsdm_db_mirroring_past_actionsdm_db_missing_index_detailsdm_db_missing_index_group_statsdm_db_missing_index_groupsdm_db_partition_statsdm_db_persisted_sku_featuresdm_db_script_leveldm_db_session_space_usagedm_db_task_space_usagedm_exec_background_job_queuedm_exec_background_job_queue_statsdm_exec_cached_plansdm_exec_connectionsdm_exec_procedure_statsdm_exec_query_memory_grantsdm_exec_query_optimizer_infodm_exec_query_resource_semaphoresdm_exec_query_statsdm_exec_query_transformation_statsdm_exec_requestsdm_exec_sessionsdm_exec_trigger_statsdm_filestream_file_io_handlesdm_filestream_file_io_requestsdm_fts_active_catalogsdm_fts_fdhostsdm_fts_index_populationdm_fts_memory_buffersdm_fts_memory_poolsdm_fts_outstanding_batchesdm_fts_population_rangesdm_io_backup_tapesdm_io_cluster_shared_drivesdm_io_pending_io_requestsdm_os_buffer_descriptorsdm_os_child_instancesdm_os_cluster_nodesdm_os_dispatcher_poolsdm_os_dispatchersdm_os_hostsdm_os_latch_statsdm_os_loaded_modulesdm_os_memory_allocationsdm_os_memory_brokersdm_os_memory_cache_clock_handsdm_os_memory_cache_countersdm_os_memory_cache_entriesdm_os_memory_cache_hash_tablesdm_os_memory_clerksdm_os_memory_node_access_statsdm_os_memory_nodesdm_os_memory_objectsdm_os_memory_poolsdm_os_nodesdm_os_performance_countersdm_os_process_memorydm_os_ring_buffersdm_os_schedulersdm_os_spinlock_statsdm_os_stacksdm_os_sublatchesdm_os_sys_infodm_os_sys_memorydm_os_tasksdm_os_threadsdm_os_virtual_address_dumpdm_os_wait_statsdm_os_waiting_tasksdm_os_windows_infodm_os_worker_local_storagedm_os_workersdm_qn_subscriptionsdm_repl_articlesdm_repl_schemasdm_repl_tranhashdm_repl_traninfodm_resource_governor_configurationdm_resource_governor_resource_poolsdm_resource_governor_workload_groupsdm_server_audit_statusdm_server_memory_dumpsdm_server_registrydm_server_servicesdm_tran_active_snapshot_database_transactionsdm_tran_active_transactionsdm_tran_commit_tabledm_tran_current_snapshotdm_tran_current_transactiondm_tran_database_transactionsdm_tran_locksdm_tran_session_transactionsdm_tran_top_version_generatorsdm_tran_transactions_snapshotdm_tran_version_storedm_xe_map_valuesdm_xe_object_columnsdm_xe_objectsdm_xe_packagesdm_xe_session_event_actionsdm_xe_session_eventsdm_xe_session_object_columnsdm_xe_session_targetsdm_xe_sessions

 

4. 查看的时候  根据选择查看即可

select * from sys.dm_tran_locks