![]() ![]() SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT = ON ![]() When this option is set to ON, access to a memory-optimized table under a lower isolation level is automatically elevated to SNAPSHOT isolation. The need for the WITH (SNAPSHOT) hint can be avoided through the use of the database option MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT. JOIN dbo.Customer as c on c.CustomerId = o.CustomerId SET TRANSACTION ISOLATION LEVEL READ COMMITTED īEGIN TRANSACTION - Explicit transaction.ĭbo.Order_mo as o WITH (SNAPSHOT) - Table hint. Provide a supported isolation level for the memory-optimized table using a table hint, such as WITH (SNAPSHOT). It is not supported for explicit or implicit transactions. If this hint is removed, the script would suffer an error 41368, for which an automated retry would be inappropriate: Error 41368Īccessing memory optimized tables using the READ COMMITTED isolation level is supported only for autocommit transactions. In the case of the code example, the hint is WITH (SNAPSHOT). The hint must be for SNAPSHOT or an even more isolating level. Therefore it is necessary to have a table hint on the memory-optimized table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |