We are currently migrating to in-memory tables on SQL Server 2019 Standard Edition. The disk based table is 55GB data 54Gb of indexes (71M records). RAM is 900 GB. But during data migration (INSERT statement) we get an error message:
Msg 41823, Level 16, State 109, Line 150 Could not perform the operation because the database has reached its quota for in-memory tables. This error may be transient. Please retry the operation.
The in-memory file is “unlimited”, so it looks strange since SQL Server 2019 should not have any size restrictions for in-memory tables.
CodePudding user response:
Why do you think in-memory data size in a single mem-opt table is unlimited on standard edition?