Memory-Optimized Tables

Monitor Memory Optimized Table Space Usage :

All Memory Used by Memory Optimized Table across Database Engine

Enable Natively Compiled Stored Procedure Stats Collection

DBCC FREEPROCCACHE does not remove natively compiled stored procedures from Plan Cache

Errors Encountered During Migration :

Msg 41317, Level 16, State 5, Line 6
A user transaction that accesses memory optimized tables or natively compiled modules cannot access more than one user database or databases model and msdb, and it cannot write to master.

Leave a Reply

Your email address will not be published. Required fields are marked *