Database Related Dynamic Management Views (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This section describes the following dynamic management objects in SQL Server and sometimes in SQL Database.

sys.dm_db_file_space_usage sys.dm_db_fts_index_physical_stats
sys.dm_db_log_info sys.dm_db_log_space_usage
sys.dm_db_log_stats sys.dm_db_partition_stats
sys.dm_db_persisted_sku_features sys.dm_db_session_space_usage
sys.dm_db_task_space_usage sys.dm_db_uncontained_entities

DMV's unique to SQL Database or SQL Data Warehouse.

sys.dm_db_wait_stats (Azure SQL Database) sys.dm_database_copies (Azure SQL Database)
sys.dm_db_resource_stats (Azure SQL Database) sys.dm_db_objects_impacted_on_version_change (Azure SQL Database)
sys.dm_operation_status (Azure SQL Database)

See Also

Dynamic Management Views and Functions (Transact-SQL)