Sqlserver 系统视图简单说明

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

select * from sys.system_views

2. 查看全部的 dynamic management 视图的sqlsql

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

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

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

 

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

select * from sys.dm_tran_locks
相关文章
相关标签/搜索