database-related-dynamic-management-views-transact-sql.md

title	Database Related Dynamic Management Views (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	05/18/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	database dynamic management objects [SQL Server] dynamic management objects [SQL Server], database
ms.assetid	615e9440-32a3-4ec4-94c6-94547e10ebda
caps.latest.revision	20
author	BYHAM
ms.author	rickbyh
manager	jhubbard

Database Related Dynamic Management Views (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx_md]

This section describes the following dynamic management objects in [!INCLUDEssNoVersion_md] 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)