Exibições de gerenciamento dinâmico relacionadas a bancos de dados (Transact-SQL)Database Related Dynamic Management Views (Transact-SQL)

APLICA-SE A: simSQL Server nãoBanco de Dados SQL do Azure nãoAzure Synapse Analytics (SQL DW) nãoParallel Data Warehouse APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

Esta seção descreve os seguintes objetos de gerenciamento dinâmico SQL ServerSQL Server no e, às vezes, no banco de dados SQL.This section describes the following dynamic management objects in SQL ServerSQL Server and sometimes in SQL Database.

sys.dm_db_file_space_usagesys.dm_db_file_space_usage sys.dm_db_fts_index_physical_statssys.dm_db_fts_index_physical_stats
sys.dm_db_log_infosys.dm_db_log_info sys.dm_db_log_space_usagesys.dm_db_log_space_usage
sys.dm_db_log_statssys.dm_db_log_stats sys.dm_db_page_infosys.dm_db_page_info
sys.dm_db_partition_statssys.dm_db_partition_stats sys.dm_db_persisted_sku_featuressys.dm_db_persisted_sku_features
sys.dm_db_session_space_usagesys.dm_db_session_space_usage sys.dm_db_task_space_usagesys.dm_db_task_space_usage
sys.dm_db_uncontained_entitiessys.dm_db_uncontained_entities

De DMV exclusivo para banco de dados SQL ou SQL Data Warehouse.DMV's unique to SQL Database or SQL Data Warehouse.

sys. dm_db_wait_stats (banco de dados SQL do Azure)sys.dm_db_wait_stats (Azure SQL Database) sys. dm_database_copies (banco de dados SQL do Azure)sys.dm_database_copies (Azure SQL Database)
sys. dm_db_resource_stats (banco de dados SQL do Azure)sys.dm_db_resource_stats (Azure SQL Database) sys. dm_db_objects_impacted_on_version_change (banco de dados SQL do Azure)sys.dm_db_objects_impacted_on_version_change (Azure SQL Database)
sys. dm_operation_status (banco de dados SQL do Azure)sys.dm_operation_status (Azure SQL Database)

Consulte TambémSee Also

Exibições e funções de gerenciamento dinâmico (Transact-SQL)Dynamic Management Views and Functions (Transact-SQL)