Ads

16 December 2011

DMF

Replication Related DMV

Resource Governor Related DMV


  1. sys.dm_resource_governor_configuration (Transact-SQL)
  2. sys.dm_resource_governor_workload_groups (Transact-SQL)
  3. sys.dm_resource_governor_resource_pools (Transact-SQL)


SQL Server Operating System Related DMV


  1. sys.dm_os_buffer_descriptors (Transact-SQL)
  2. sys.dm_os_memory_pools (Transact-SQL)
  3. sys.dm_os_child_instances (Transact-SQL)
  4. sys.dm_os_nodes (Transact-SQL)
  5. sys.dm_os_cluster_nodes (Transact-SQL)
  6. sys.dm_os_performance_counters (Transact-SQL)
  7. sys.dm_os_dispatcher_pools (Transact-SQL)
  8. sys.dm_os_process_memory (Transact-SQL)
  9. sys.dm_os_hosts (Transact-SQL)
  10. sys.dm_os_schedulers (Transact-SQL)
  11. sys.dm_os_latch_stats (Transact-SQL)
  12. sys.dm_os_stacks (Transact-SQL)
  13. sys.dm_os_loaded_modules (Transact-SQL)
  14. sys.dm_os_sys_info (Transact-SQL)
  15. sys.dm_os_memory_brokers (Transact-SQL)
  16. sys.dm_os_sys_memory (Transact-SQL)
  17. sys.dm_os_memory_cache_clock_hands (Transact-SQL)
  18. sys.dm_os_tasks (Transact-SQL)
  19. sys.dm_os_memory_cache_counters (Transact-SQL)
  20. sys.dm_os_threads (Transact-SQL)
  21. sys.dm_os_memory_cache_entries (Transact-SQL)
  22. sys.dm_os_virtual_address_dump (Transact-SQL)
  23. sys.dm_os_memory_cache_hash_tables (Transact-SQL)
  24. sys.dm_os_volume_stats (Transact-SQL)
  25. sys.dm_os_memory_clerks (Transact-SQL)
  26. sys.dm_os_wait_stats (Transact-SQL)
  27. sys.dm_os_memory_nodes (Transact-SQL)
  28. sys.dm_os_waiting_tasks (Transact-SQL)
  29. sys.dm_os_memory_objects (Transact-SQL)
  30. sys.dm_os_windows_info (Transact-SQL)
  31. sys.dm_os_workers (Transact-SQL)

Service Broker Related DMV


  1. sys.dm_broker_activated_tasks
  2. sys.dm_broker_connections
  3. sys.dm_broker_forwarded_messages
  4. sys.dm_broker_queue_monitors


Index Related DMV

Change Data Capture Related DMV


No comments:

Post a Comment