Skip to content

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

Latest commit

 

History

History
70 lines (50 loc) · 3.63 KB

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

File metadata and controls

70 lines (50 loc) · 3.63 KB
title Database Related Dynamic Management Views (Transact-SQL)
description Database Related Dynamic Management Views (Transact-SQL)
author rwestMSFT
ms.author randolphwest
ms.date 05/18/2017
ms.service sql
ms.subservice system-objects
ms.topic reference
helpviewer_keywords
database dynamic management objects [SQL Server]
dynamic management objects [SQL Server], database
dev_langs
TSQL
ms.assetid 615e9440-32a3-4ec4-94c6-94547e10ebda

Database Related Dynamic Management Views (Transact-SQL)

[!INCLUDE SQL Server]

This section describes the following dynamic management objects in [!INCLUDEssNoVersion_md] and sometimes in SQL Database.

:::row::: :::column::: sys.dm_db_file_space_usage

    [sys.dm_db_log_info](../../relational-databases/system-dynamic-management-views/sys-dm-db-log-info-transact-sql.md)

    [sys.dm_db_log_stats](../../relational-databases/system-dynamic-management-views/sys-dm-db-log-stats-transact-sql.md)

    [sys.dm_db_partition_stats](../../relational-databases/system-dynamic-management-views/sys-dm-db-partition-stats-transact-sql.md)

    [sys.dm_db_session_space_usage](../../relational-databases/system-dynamic-management-views/sys-dm-db-session-space-usage-transact-sql.md)

    [sys.dm_db_uncontained_entities](../../relational-databases/system-dynamic-management-views/sys-dm-db-uncontained-entities-transact-sql.md)
:::column-end:::
:::column:::
    [sys.dm_db_fts_index_physical_stats](../../relational-databases/system-dynamic-management-views/sys-dm-db-fts-index-physical-stats-transact-sql.md)

    [sys.dm_db_log_space_usage](../../relational-databases/system-dynamic-management-views/sys-dm-db-log-space-usage-transact-sql.md)

    [sys.dm_db_page_info](../../relational-databases/system-dynamic-management-views/sys-dm-db-page-info-transact-sql.md)

    [sys.dm_db_persisted_sku_features](../../relational-databases/system-dynamic-management-views/sys-dm-db-persisted-sku-features-transact-sql.md)

    [sys.dm_db_task_space_usage](../../relational-databases/system-dynamic-management-views/sys-dm-db-task-space-usage-transact-sql.md)
:::column-end:::

:::row-end:::

DMV's unique to SQL Database or Azure Synapse Analytics.

:::row::: :::column::: sys.dm_db_wait_stats (Azure SQL Database)

    [sys.dm_db_resource_stats (Azure SQL Database)](../../relational-databases/system-dynamic-management-views/sys-dm-db-resource-stats-azure-sql-database.md)

    [sys.dm_operation_status (Azure SQL Database)](../../relational-databases/system-dynamic-management-views/sys-dm-operation-status-azure-sql-database.md)
:::column-end:::
:::column:::
    [sys.dm_database_copies (Azure SQL Database)](../../relational-databases/system-dynamic-management-views/sys-dm-database-copies-azure-sql-database.md)

    [sys.dm_db_objects_impacted_on_version_change (Azure SQL Database)](../../relational-databases/system-dynamic-management-views/sys-dm-db-objects-impacted-on-version-change-azure-sql-database.md)
:::column-end:::

:::row-end:::

See Also

Dynamic Management Views and Functions (Transact-SQL)