{"id":107,"date":"2012-01-05T12:04:41","date_gmt":"2012-01-05T12:04:41","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/01\/05\/why-is-sql-server-consuming-lot-of-ram\/"},"modified":"2012-01-05T12:04:41","modified_gmt":"2012-01-05T12:04:41","slug":"why-is-sql-server-consuming-lot-of-ram","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/01\/05\/why-is-sql-server-consuming-lot-of-ram\/","title":{"rendered":"Why is SQL Server consuming Lot of RAM"},"content":{"rendered":"<p><strong>Why is SQL Server consuming Lot of RAM<\/strong><\/p>\n<p>There could be multiple reasons why SQL Server is consuming lot of physical memory (RAM).<\/p>\n<p>Following are the few that I would like to list out:<\/p>\n<p>1) Performance of the server could be bad as the queries that are hitting the sever are not optimal.<br \/>\n<em>You can further fine tune such queries.<\/em><\/p>\n<p>2) Maximum and Minimum server memory configuration is not set up properly.<br \/>\nYou can set up maximum server memory configuration so that it doesnt eat up whole of the RAM.<\/p>\n<p>Following are the Steps to configure sql server memory allocation:<\/p>\n<ul>\n<li>Connect to the SQL Server in SQL Server management studio<\/li>\n<li>Right click on the server and click on properties<\/li>\n<li>\nNow the Server Properties window pops up.<br \/>\nIn the Server Properties window Select Memory.<br \/>\nNow check the values of<br \/>\n<strong>Minimum Server Memory(in MB)<\/strong> and <strong>Maximum Server Memory(in MB)<\/strong><\/p>\n<p><figure id=\"attachment_1361\" aria-describedby=\"caption-attachment-1361\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"\/wp-content\/uploads\/2012\/01\/Configure-Maximum-And-Minimum-SQL-Server-Memory.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2012\/01\/Configure-Maximum-And-Minimum-SQL-Server-Memory.jpg\" alt=\"Configure Maximum And Minimum SQL Server Memory\" title=\"Configure Maximum And Minimum SQL Server Memory\" width=\"300\" height=\"268\" class=\"size-medium wp-image-1361\"><\/a><figcaption id=\"caption-attachment-1361\" class=\"wp-caption-text\">Configure Maximum And Minimum SQL Server Memory<\/figcaption><\/figure><\/li>\n<li>Adjust these values to opimal memory values as per your SQL Server&#8217;s memory requirement.<\/li>\n<\/ul>\n<p><strong>Note:<\/strong> Be aware that changing the memory configuration of SQL Server might give you very bad results. Hence be cautious before making such changes.<br \/>\nYou might also get <a href=\"http:\/\/sqlserverlearner.com\/2011\/there-is-insufficient-system-memory-in-resource-pool-default-to-run-this-query\" target=\"_blank\" rel=\"noopener noreferrer\">There is insufficient system memory in resource pool \u2018default\u2019 to run this query<\/a> error if memory configuration is bad.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Why is SQL Server consuming Lot of RAM There could be multiple reasons why SQL Server is consuming lot of physical memory (RAM). Following are the few that I would like to list out: 1) Performance of the server could be bad as the queries that are hitting the sever are not optimal. You can&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,41,186,273,3],"tags":[672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/107"}],"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=107"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/107\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}