Question: How to List All Memory Optimized Tables in SQL Server? We will see two different scripts here: One for Database and Second for Tables.
Memory-Optimized tempdb Metadata: Turning It On and Checking It
Diagnose memory-optimized tempdb metadata candidates, plan the required restart, verify activation, and monitor contention and memory.
Instance Health in One Query: Uptime, Memory, CPU and Waits
Check instance health in one result set with uptime, memory, a recent CPU sample, leading waits, and the user-session count.
In-Memory OLTP Migration Checklist in SSMS: Step by Step
The In-Memory OLTP migration checklist shows which tables and stored procedures can move to memory-optimized objects. This post sizes up the tables with T-SQL, walks through the wizard in Management Studio and explains how to read the reports.
SQL SERVER – Fix Error – Restore Operation Failed for Database Due to Insufficient Memory in the Resource Pool ‘Default’
SQL SERVER – Fix Error – Restore Operation Failed for Database Due to Insufficient Memory in the Resource Pool ‘Default’
SQL SERVER – Error Msg 10778, Level 16 with InMemory OLTP
Can an InMemory table have a foreign key to a disk-based table? I tried it and got Msg 10778. Here is what the error means and the limits to know.
SQL SERVER – Using dm_db_stats_properties With InMemory OLTP Tables
Does sys.dm_db_stats_properties show modified rows for InMemory OLTP tables? I tested it, and memory-optimized tables are now covered. Here is what I found.