In-Memory OLTP SQL Server - insufficient system memory

fernando satonni 1 Reputation point
2021-02-24T13:09:50.78+00:00

Hello,

I am trying to place an In-Memory OLTP table,

Here is the memory estimate you will need:

71576-oltp-error4.jpg

71588-oltp-error5.jpg

But when the migration starts, the following error message is displayed:

71565-oltp-error3.jpg

The size of my table is approximately 22GB

71470-oltp-error2.jpg

I have a server with 64GB of memory and I allocated it for SQL 56GB, and to put the table in memory I only need 23GB

71589-oltp-error6.jpg
71546-oltp-error8.jpg
71566-oltp-error7.jpg

Can anybody help me?
Thanks.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,323 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,611 Reputation points
    2021-02-25T08:07:19.897+00:00

    Hi,

    The Memory-Optimization Advisor estimates the amount of memory the new memory-optimized table will consume based on metadata of the disk-based table. If sufficient memory is not allotted, the migration process may fail.

    If your SQL Server is Enterprise or Developer edition that supports Resource governor feature, creating a separate resource pool may help your problem.

    If you have not created a named resource pool for your in-memory tables you should do that and bind your In-Memory OLTP databases to it. See the topic Bind a Database with Memory-Optimized Tables to a Resource Pool for guidance on creating and binding your In-Memory OLTP databases to a resource pool.
    https://learn.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/resolve-out-of-memory-issues?view=sql-server-ver15#increase-available-memory