Monitor the impact of memory optimized tables on server memory. Identify high memory utilizing tables. Assess server memory capacity. Simulate moving to In-Memory OLTP.
Version: 126.96.36.199810Monitor the Performance of SQL memory-optimized tables: Monitor the impact of memory optimized tables on server memory. Identify top memory-utilizing tables. Assess server memory capacity.
Operating System: Windows
Simulate moving to In-memory online transaction processing (OLTP).
Memory-optimized tables significantly increase the execution speed of operations. However, they also increase system memory usage, potentially affecting other operations.
SQL Hekaton Memory check monitors the memory use of memory-optimized tables and provides visualizations of their impact on server memory capacity.
Monitor memory-optimized tables: Using memory-optimized tables has the potential to stress system memory resources as transaction volume rises.
This tool allows you to monitor the utilization of system memory by memory-optimized tables so that you can see the overall impact in real-time and make adjustments as needed to improve performance.
Identify top memory hogs: Connecting to an instance lists databases that contain memory-optimized tables.
View memory utilization of these databases and see details about individual tables within each database to identify the top memory consumers.
Support capacity planning: Check the ongoing impact of memory optimized tables on system memory utilization to identify trends and help with memory capacity planning.
Simulate moving to in-memory online transaction processing (OLTP): Monitor sample and test movements of processing to memory-optimized tables to simulate larger migrations to in-memory online transaction processing (OLTP) with SQL Server 2014.
Version 188.8.131.52810: This is a new product