Dynamic Management Views for In-Memory OLTP
The introduction of In-Memory OLTP in SQL Server 2014 brings with it a number of new DMVs that provide information about the In-Memory OLTP engine and memory-optimized tables and indexes. Each of these new DMVs and functions that contain “xtp” (an acronym of eXtreme Transaction Processing) in its name refers to the In-Memory OLTP Engine.
There are two types of In-Memory OLTP Dynamic Management Views. The Database specific DMVs provide information and statistics for the current database and start with “sys.dm_db_xtp_”. Instance specific DMVs return information and statistics concerning the entire In-Memory OLTP Engine of the instance and start with “sys.dm_xtp_”.
A number of the new DMVs have been presented ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
