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
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें