Database Related Dynamic Management Views (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2012) noAzure SQL Database noAzure 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_page_info
sys.dm_db_partition_stats sys.dm_db_persisted_sku_features
sys.dm_db_session_space_usage sys.dm_db_task_space_usage

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)