Memory-Optimized Table Dynamic Management Views (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
The following SQL Server dynamic management views (DMVs) are used with In-Memory OLTP:
For more information, see In-Memory OLTP (In-Memory Optimization).
sys.dm_db_xtp_checkpoint_stats (Transact-SQL)
sys.dm_db_xtp_gc_cycle_stats (Transact-SQL)
sys.dm_db_xtp_index_stats (Transact-SQL)
sys.dm_db_xtp_merge_requests (Transact-SQL)
sys.dm_db_xtp_nonclustered_index_stats (Transact-SQL)
sys.dm_db_xtp_transactions (Transact-SQL)
Object Catalog Views
The following object catalog views are used specifically with In-Memory OLTP.
Internal DMVs
There are additional DMVs that are intended for internal use only, and for which we provide no direct documentation. In the area of memory-optimized tables, undocumented DMVs include the following:
- sys.dm_xtp_threads
- sys.dm_xtp_transaction_recent_rows
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru