SQL-Hekaton-Memory-Check

Short Description:
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.

Long Description 1:
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.

Long Description 2:
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.