{"id":73,"date":"2011-12-06T14:50:12","date_gmt":"2011-12-06T14:50:12","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/12\/06\/there-is-insufficient-system-memory-in-resource-pool-default-to-run-this-query\/"},"modified":"2011-12-06T14:50:12","modified_gmt":"2011-12-06T14:50:12","slug":"there-is-insufficient-system-memory-in-resource-pool-default-to-run-this-query","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/12\/06\/there-is-insufficient-system-memory-in-resource-pool-default-to-run-this-query\/","title":{"rendered":"There is insufficient system memory in resource pool &#8216;default&#8217; to run this query"},"content":{"rendered":"<p>When you try to execute a query on SQL Server you get the error: <strong>There is insufficient system memory in resource pool &#8216;default&#8217; to run this query.<\/strong><\/p>\n<p>This memory problem would also occur in the following cases:<\/p>\n<ul>\n<li>While executing a query on SSMS.<\/li>\n<li>Trying to connect to a sql server in Sql server management studio<\/li>\n<li>Trying to execute a SQL Query using OSQL in the command prompt<\/li>\n<li>While executing a stored procedure<\/li>\n<li>Using power shell to connect to SQL Server<\/li>\n<\/ul>\n<p>In most of the cases the query would run successfully for some time and then encounter this error.<\/p>\n<p>Possible reasons for this error:<\/p>\n<ul>\n<li>The main reason would be un availability of allocated physical memory to sql server.<\/li>\n<li>The ram would be completely used<\/li>\n<li>SQL Server\u2019s maximum memory allocation configured value has been reached.<\/li>\n<li>Virtual memory is full<\/li>\n<\/ul>\n<p><strong><em>Fix for this error:<\/em><\/strong><br \/>\n<strong>Try to allocate more memory to sql server server.<\/strong><br \/>\nSteps to allocate memory are given below:<\/p>\n<ul>\n<li>Connect to SQL Server management studio<\/li>\n<li>Right click on the server and click on properties<\/li>\n<li>Select Memory<\/li>\n<li>Increase the value for Maximum Server Memory(in MB).\n<p><figure id=\"attachment_674\" aria-describedby=\"caption-attachment-674\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"\/wp-content\/uploads\/2011\/12\/insufficient-system-memory-in-resource-pool-error-sql-server.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2011\/12\/insufficient-system-memory-in-resource-pool-error-sql-server.jpg\" alt=\"SQL Server Properties window\" title=\"SQL Server Properties window\" width=\"300\" height=\"271\" class=\"size-medium wp-image-674\"><\/a><figcaption id=\"caption-attachment-674\" class=\"wp-caption-text\">SQL Server Properties window<\/figcaption><\/figure><\/li>\n<\/ul>\n<p><strong>Try the following DBCC Commands <\/strong><br \/>\n[sql]DBCC FREESYSTEMCACHE (&#8216;ALL&#8217;)<br \/>\nDBCC FREESESSIONCACHE<br \/>\nDBCC FREEPROCCACHE<br \/>\nDBCC DROPCLEANBUFFERS[\/sql]<\/p>\n<p><strong>Kill all the unnecessary idle sessions on the server<\/strong><\/p>\n<p><strong>Reduce the number of users on this server<\/strong><\/p>\n<p><strong>Check the task manager and check if 100% of physical memory is being used.<\/strong><br \/>\nIf over loading of the server is the case then<\/p>\n<ul>\n<li>Remove  the applications on the server that are eating up much of the physical memory<\/li>\n<li>increase the RAM on the server<\/li>\n<li>increase virtual memory on the server<\/li>\n<\/ul>\n<p><strong>Optionally re start the SQL Server Service<\/strong><\/p>\n<p>Now check if the query is causing the same error.<\/p>\n<p>Before making any changes to the server understand the pros and cons of the action performed by reading Microsoft documentation clearly.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you try to execute a query on SQL Server you get the error: There is insufficient system memory in resource pool &#8216;default&#8217; to run this query. This memory problem would also occur in the following cases: While executing a query on SSMS. Trying to connect to a sql server in Sql server management studio&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128,3],"tags":[207,208,209,210],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/73"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=73"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/73\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=73"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=73"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}