There is insufficient system memory in resource pool to run this query

Error message:

There is insufficient system memory in resource pool to run this query

Possible solutions and checks:

Check the physical memory of the server, it's probably 100% of it is being used.

Possible fixes can be:

• Limit or increase the maximum server memory of the server (SSMS-->DB properties-->Memory). If you have enough RAM on the server - increase the memory, if not - check the limitation.
• Remove applications on the server that use much of the physical memory.
• Increase the RAM on the server.
• You can also restart the SQL Server Service, but it's just a quick solution, not permanent.