Exibições de gerenciamento dinâmico da tabela com otimização de memória (Transact-SQL)Memory-Optimized Table Dynamic Management Views (Transact-SQL)

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

As seguintes SQL ServerSQL Server DMVs (exibições de gerenciamento dinâmico) são usadas com o OLTP na memória:The following SQL ServerSQL Server dynamic management views (DMVs) are used with In-Memory OLTP:

Para obter mais informações, veja OLTP in-memory (Otimização na memória).For more information, see In-Memory OLTP (In-Memory Optimization).

sys. dm_db_xtp_checkpoint_stats (Transact-SQL)sys.dm_db_xtp_checkpoint_stats (Transact-SQL) sys. dm_db_xtp_checkpoint_files (Transact-SQL)sys.dm_db_xtp_checkpoint_files (Transact-SQL)
sys. dm_db_xtp_gc_cycle_stats (Transact-SQL)sys.dm_db_xtp_gc_cycle_stats (Transact-SQL) sys.dm_db_xtp_hash_index_stats (Transact-SQL)sys.dm_db_xtp_hash_index_stats (Transact-SQL)
sys.dm_db_xtp_index_stats (Transact-SQL)sys.dm_db_xtp_index_stats (Transact-SQL) sys. dm_db_xtp_memory_consumers (Transact-SQL)sys.dm_db_xtp_memory_consumers (Transact-SQL)
sys.dm_db_xtp_merge_requests (Transact-SQL)sys.dm_db_xtp_merge_requests (Transact-SQL) sys.dm_db_xtp_object_stats (Transact-SQL)sys.dm_db_xtp_object_stats (Transact-SQL)
sys.dm_db_xtp_nonclustered_index_stats (Transact-SQL)sys.dm_db_xtp_nonclustered_index_stats (Transact-SQL) sys.dm_db_xtp_table_memory_stats (Transact-SQL)sys.dm_db_xtp_table_memory_stats (Transact-SQL)
sys. dm_db_xtp_transactions (Transact-SQL)sys.dm_db_xtp_transactions (Transact-SQL) sys. dm_xtp_gc_queue_stats (Transact-SQL)sys.dm_xtp_gc_queue_stats (Transact-SQL)
sys. dm_xtp_gc_stats (Transact-SQL)sys.dm_xtp_gc_stats (Transact-SQL) sys. dm_xtp_system_memory_consumers (Transact-SQL)sys.dm_xtp_system_memory_consumers (Transact-SQL)
sys. dm_xtp_transaction_stats (Transact-SQL)sys.dm_xtp_transaction_stats (Transact-SQL)

Exibições do catálogo de objetoObject Catalog Views

As exibições de catálogo de objetos a seguir são usadas especificamente com o OLTP na memória.The following object catalog views are used specifically with In-Memory OLTP.

sys.hash_indexes (Transact-SQL)sys.hash_indexes (Transact-SQL) sys.memory_optimized_tables_internal_attributes (Transact-SQL)sys.memory_optimized_tables_internal_attributes (Transact-SQL)

DMVs internosInternal DMVs

Há DMVs adicionais que se destinam somente ao uso interno e para os quais não fornecemos nenhuma documentação direta.There are additional DMVs that are intended for internal use only, and for which we provide no direct documentation. Na área de tabelas com otimização de memória, DMVs não documentados incluem o seguinte:In the area of memory-optimized tables, undocumented DMVs include the following:

  • sys. dm_xtp_threadssys.dm_xtp_threads
  • sys. dm_xtp_transaction_recent_rowssys.dm_xtp_transaction_recent_rows