Replication Related DMV
Database Mirroring Related DMV
I/O Related DMV
Resource Governor Related DMV
- sys.dm_resource_governor_configuration (Transact-SQL)
- sys.dm_resource_governor_workload_groups (Transact-SQL)
- sys.dm_resource_governor_resource_pools (Transact-SQL)
SQL Server Operating System Related DMV
- sys.dm_os_buffer_descriptors (Transact-SQL)
- sys.dm_os_memory_pools (Transact-SQL)
- sys.dm_os_child_instances (Transact-SQL)
- sys.dm_os_nodes (Transact-SQL)
- sys.dm_os_cluster_nodes (Transact-SQL)
- sys.dm_os_performance_counters (Transact-SQL)
- sys.dm_os_dispatcher_pools (Transact-SQL)
- sys.dm_os_process_memory (Transact-SQL)
- sys.dm_os_hosts (Transact-SQL)
- sys.dm_os_schedulers (Transact-SQL)
- sys.dm_os_latch_stats (Transact-SQL)
- sys.dm_os_stacks (Transact-SQL)
- sys.dm_os_loaded_modules (Transact-SQL)
- sys.dm_os_sys_info (Transact-SQL)
- sys.dm_os_memory_brokers (Transact-SQL)
- sys.dm_os_sys_memory (Transact-SQL)
- sys.dm_os_memory_cache_clock_hands (Transact-SQL)
- sys.dm_os_tasks (Transact-SQL)
- sys.dm_os_memory_cache_counters (Transact-SQL)
- sys.dm_os_threads (Transact-SQL)
- sys.dm_os_memory_cache_entries (Transact-SQL)
- sys.dm_os_virtual_address_dump (Transact-SQL)
- sys.dm_os_memory_cache_hash_tables (Transact-SQL)
- sys.dm_os_volume_stats (Transact-SQL)
- sys.dm_os_memory_clerks (Transact-SQL)
- sys.dm_os_wait_stats (Transact-SQL)
- sys.dm_os_memory_nodes (Transact-SQL)
- sys.dm_os_waiting_tasks (Transact-SQL)
- sys.dm_os_memory_objects (Transact-SQL)
- sys.dm_os_windows_info (Transact-SQL)
- sys.dm_os_workers (Transact-SQL)
Service Broker Related DMV
- sys.dm_broker_activated_tasks
- sys.dm_broker_connections
- sys.dm_broker_forwarded_messages
- sys.dm_broker_queue_monitors
Index Related DMV
- sys.dm_db_index_operational_stats (Transact-SQL)
- sys.dm_db_index_physical_stats (Transact-SQL)
- sys.dm_db_index_usage_stats (Transact-SQL)
- sys.dm_db_missing_index_columns (Transact-SQL)
- sys.dm_db_missing_index_details (Transact-SQL)
- sys.dm_db_missing_index_group_stats (Transact-SQL)
- sys.dm_db_missing_index_groups (Transact-SQL)
Database Related DMV
- sys.dm_db_file_space_usage
- sys.dm_db_session_space_usage
- sys.dm_db_partition_stats
- sys.dm_db_task_space_usagesys.dm_db_persisted_sku_features
No comments:
Post a Comment