SQL Server Dynamic management views (DMV's)

  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_algorithms

dm_cryptographic_provider_keys

dm_cryptographic_provider_properties

dm_cryptographic_provider_sessions

dm_database_encryption_keys

dm_db_file_space_usage

dm_db_index_operational_stats

dm_db_index_physical_stats

dm_db_index_usage_stats

dm_db_mirroring_auto_page_repair

dm_db_mirroring_connections

dm_db_mirroring_past_actions

dm_db_missing_index_columns

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_plan_dependent_objects

dm_exec_cached_plans

dm_exec_connections

dm_exec_cursors

dm_exec_plan_attributes

dm_exec_procedure_stats

dm_exec_query_memory_grants

dm_exec_query_optimizer_info

dm_exec_query_plan

dm_exec_query_resource_semaphores

dm_exec_query_stats

dm_exec_query_transformation_stats

dm_exec_requests

dm_exec_sessions

dm_exec_sql_text

dm_exec_text_query_plan

dm_exec_trigger_stats

dm_exec_xml_handles

dm_filestream_file_io_handles

dm_filestream_file_io_requests

dm_fts_active_catalogs

dm_fts_fdhosts

dm_fts_index_keywords

dm_fts_index_keywords_by_document

dm_fts_index_population

dm_fts_memory_buffers

dm_fts_memory_pools

dm_fts_outstanding_batches

dm_fts_parser

dm_fts_population_ranges

dm_io_backup_tapes

dm_io_cluster_shared_drives

dm_io_pending_io_requests

dm_io_virtual_file_stats

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_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_sql_referenced_entities

dm_sql_referencing_entities

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

Comments

Post a Comment

Popular posts from this blog

SQL Server DBA scripts for day-to-day tasks

   1. Check Database Size: SELECT name AS 'Database Name', size * 8 / 1024 AS 'Size (MB)' FROM sys.master_files WHERE DB_NAME(database_id) NOT IN ('master', 'tempdb', 'model', 'msdb'); 2. Check Fragmentation: SELECT OBJECT_NAME(ind.OBJECT_ID) AS 'Table', ind.name AS 'Index', indexstats.avg_fragmentation_in_percent FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats INNER JOIN sys.indexes ind ON ind.object_id = indexstats.object_id AND ind.index_id = indexstats.index_id WHERE indexstats.avg_fragmentation_in_percent > 30 ORDER BY indexstats.avg_fragmentation_in_percent DESC; 3. Backup Information: SELECT database_name, backup_start_date, backup_finish_date, compressed_backup_size/1024/1024 AS 'Backup Size (MB)' FROM msdb.dbo.backupset ORDER BY backup_start_date DESC; 4. Check Active Sessions: SELECT session_id, login_time, host_name, program_name FROM sys.dm_exec_session...
Read more

A brief comparison of Microsoft SQL Server versions from SQL Server 2012 to SQL Server 2022

 SQL Server 2012: • Introduced AlwaysOn Availability Groups for high availability. • Enhanced columnstore indexes for better data warehousing performance. • Contained Databases for easier database portability. • Improved security features, including user-defined server roles. SQL Server 2014: • In-Memory OLTP (Hekaton) introduced for improved transaction processing. • Buffer Pool Extensions for SSD integration. • Enhanced backup to Azure for improved disaster recovery. • JSON support introduced. SQL Server 2016: • PolyBase introduced for querying across relational and non-relational databases. • Stretch Database feature for hybrid cloud scenarios. • Always Encrypted for enhanced security. • Dynamic Data Masking for controlling access to sensitive data. SQL Server 2017: • Introduced support for SQL Server on Linux. • Adaptive Query Processing for improved query performance. • Graph Database capabilities. • Automatic dat...
Read more