Microsoft SQL Server: There is insufficient system memory in resource pool 'default' to run this query. (Microsoft SQL Server, Error: 701)

Wednesday, November 27, 2013

There is insufficient system memory in resource pool 'default' to run this query. (Microsoft SQL Server, Error: 701)

There is insufficient system memory in resource pool 'default' to run this query. (Microsoft SQL Server, Error: 701)

I got the above error in my SQL Server 2012 Instance when I am trying to execute any job from the SQL Server Agent and there are couple of memory errors in error log file.

After troubleshooting various issues I find SQL Server 2012 Instance memory is limited to 2 GB, I changed it to 3 GB (system memory is 4GB) then I can able to execute jobs or executing other queries.

Will post a seperate article about SQL Server 2012 memory architecture.

No comments:

Disclaimer

This is my personal blog, the views and opinions are published here are my own. All data and information provided on this site is for informational purposes only. The views and opinions expressed here are of my own and not those of the people or organizations that I may or may not be related with. The code / scripts or any kind of stuff published in this blog are not permitted or certified by my employer or Microsoft SQL Server. While following any advices from blog if you encountered any issues, author is not responsible for that.