Dynamische Verwaltungssichten für speicheroptimierte Tabellen (Transact-SQL)Memory-Optimized Table Dynamic Management Views (Transact-SQL)

Gilt für: JaSQL Server JaAzure SQL-Datenbank NeinAzure Synapse Analytics (SQL DW) NeinParallel Data Warehouse APPLIES TO: yesSQL Server yesAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

Die folgenden SQL ServerSQL Server dynamischen Verwaltungs Sichten (Dynamic Management Views, DMVs) werden mit in-Memory-OLTP verwendet:The following SQL ServerSQL Server dynamic management views (DMVs) are used with In-Memory OLTP:

Weitere Informationen finden Sie unter In-Memory OLTP (Arbeitsspeicheroptimierung).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)

Katalogsichten für ObjekteObject Catalog Views

Die folgenden Objektkatalog Sichten werden speziell mit in-Memory OLTP verwendet.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)

Interne DMVsInternal DMVs

Es gibt zusätzliche DMVs, die nur für die interne Verwendung vorgesehen sind und für die wir keine direkte Dokumentation bereitstellen.There are additional DMVs that are intended for internal use only, and for which we provide no direct documentation. Im Bereich Speicher optimierter Tabellen umfassen nicht dokumentierte DMVs Folgendes: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