SQL Hekaton Memory Check 1.0.0.36810

Monitor 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. 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.