{"id":131,"date":"2011-12-24T17:27:34","date_gmt":"2011-12-24T17:27:34","guid":{"rendered":"http:\/\/www.itcrumbs.com\/?p=131"},"modified":"2019-02-07T04:40:23","modified_gmt":"2019-02-07T04:40:23","slug":"sbs-2011-wsus-sql-memory-usage-is-very-high-how-to-reduce-it-from-mpecs-inc-blog","status":"publish","type":"post","link":"http:\/\/www.itcrumbs.com\/?p=131","title":{"rendered":"SBS 2011 &ndash; WSUS SQL Memory Usage Is Very High &ndash; How To Reduce It from MPECS Inc. Blog"},"content":{"rendered":"<p><a title=\"http:\/\/blog.mpecsinc.ca\/2011\/07\/sbs-2011-wsus-sql-memory-usage-is-very.html\" href=\"http:\/\/blog.mpecsinc.ca\/2011\/07\/sbs-2011-wsus-sql-memory-usage-is-very.html\">http:\/\/blog.mpecsinc.ca\/2011\/07\/sbs-2011-wsus-sql-memory-usage-is-very.html<\/a><\/p>\n<p>Our destination SBS 2011 has an SQL (S-Q-L) process that was taking up a whopping 5GB of RAM:<\/p>\n<p><a href=\"http:\/\/lh4.ggpht.com\/-2Mkv5aUZAB4\/Tg6s0VRUH-I\/AAAAAAAAFYs\/ETYW2hZi3so\/s1600-h\/image3.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" border=\"0\" alt=\"image\" src=\"http:\/\/lh4.ggpht.com\/-mKK6_VO-3So\/Tg6s0_OqYUI\/AAAAAAAAFYw\/DDkqLgOnAds\/image_thumb1.png?imgmax=800\" width=\"640\" height=\"54\" \/><\/a><\/p>\n<p>Since this was a relatively fresh install of SBS 2011 we needed to find out what SQL setup was using so much memory.<\/p>\n<ol>\n<li>Open Task Manager \u2013&gt; Processes tab. <\/li>\n<li><a href=\"http:\/\/blog.mpecsinc.ca\/2010\/12\/sbs-2011-setup-guide-v100.html\">View \u2013&gt; Choose Columns \u2013&gt; PID, Memory, etc.<\/a> (<em>Our SBS 2011 Setup Guide has the customizations<\/em>) <\/li>\n<li>Start \u2013&gt; CMD \u2013&gt; Right click and Run As Admin. <\/li>\n<li>tasklist \/svc [Enter] <\/li>\n<li>Scroll through the resulting list looking for the PID.\n<ul>\n<li><a href=\"http:\/\/lh5.ggpht.com\/-U-IPvPu2U_w\/Tg6s1KFa2tI\/AAAAAAAAFY0\/gJoCAaOvFJ0\/s1600-h\/image7.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" border=\"0\" alt=\"image\" src=\"http:\/\/lh3.ggpht.com\/-_oYoQmqIcmI\/Tg6s1wrtYxI\/AAAAAAAAFY4\/yFRFpnOkvWA\/image_thumb3.png?imgmax=800\" width=\"569\" height=\"44\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li>Start \u2013&gt; All Programs \u2013&gt; Microsoft SQL Server 2008 R2 \u2013&gt; Right click and Run as Admin on <strong>SQL Server Management Studio<\/strong>.\n<ul>\n<li>Server type: Database Engine. <\/li>\n<li>Server name: \\\\.\\pipe\\mssql$microsoft##ssee\\sql\\query\n<ul>\n<li>Copy and paste the above. <\/li>\n<\/ul>\n<\/li>\n<li>Authentication: Windows Authentication. <\/li>\n<\/ul>\n<\/li>\n<li>Click <strong>Connect<\/strong>.\n<ol>\n<li><a href=\"http:\/\/lh4.ggpht.com\/-Hq52pcD_nfY\/Tg6s2B85pvI\/AAAAAAAAFY8\/s1pTCC6NepM\/s1600-h\/image11.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" border=\"0\" alt=\"image\" src=\"http:\/\/lh5.ggpht.com\/-JFlh5nHIG5s\/Tg6s29QfzkI\/AAAAAAAAFZA\/IpbkPv1r_Qk\/image_thumb5.png?imgmax=800\" width=\"277\" height=\"117\" \/><\/a><\/li>\n<\/ol>\n<\/li>\n<li>Right click the root node (\\\\.\\pipe\\mssql$microsoft##ssee\\sql\\query) and left click on <strong>Properties<\/strong>. <\/li>\n<li>Click <strong>Memory<\/strong>. <\/li>\n<li>Change the amount of memory that WSUS can use. On this particular SBS 2011 VM we have 16GB of RAM allocated. So, we will set the amount of RAM to 1GB.\n<ol>\n<li>Before:\n<ul>\n<li><a href=\"http:\/\/lh6.ggpht.com\/-4K93vKijDgs\/Tg6s3YAKn_I\/AAAAAAAAFZE\/aiPBVwfKIGw\/s1600-h\/image18.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" border=\"0\" alt=\"image\" src=\"http:\/\/lh6.ggpht.com\/-YmPhPdYJC8s\/Tg6s3qGhZxI\/AAAAAAAAFZI\/U-cmQ5xi54Y\/image_thumb8.png?imgmax=800\" width=\"473\" height=\"311\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li>After:\n<ul>\n<li><a href=\"http:\/\/lh5.ggpht.com\/-nieQsrbBSCU\/Tg6s4OvCGnI\/AAAAAAAAFZM\/7zJR8aPrLy0\/s1600-h\/image22.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" border=\"0\" alt=\"image\" src=\"http:\/\/lh3.ggpht.com\/-yRtizFSfu7o\/Tg6s4sLaNtI\/AAAAAAAAFZQ\/M8CVUVRSkVg\/image_thumb10.png?imgmax=800\" width=\"475\" height=\"289\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>Our WSUS SQL memory usage was now a lot more reasonable:<\/p>\n<p><a href=\"http:\/\/lh3.ggpht.com\/-yAh_W4MNe28\/Tg6s5LVQQ_I\/AAAAAAAAFZU\/rdQ29JTefxk\/s1600-h\/image29.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" border=\"0\" alt=\"image\" src=\"http:\/\/lh3.ggpht.com\/-g3XR2OTfTDo\/Tg6s5jCqcEI\/AAAAAAAAFZY\/W5-uvvhOHRs\/image_thumb13.png?imgmax=800\" width=\"622\" height=\"99\" \/><\/a><\/p>\n<p><a href=\"http:\/\/lh5.ggpht.com\/-KJg4AyE2aNU\/Tg6s6Dk6XlI\/AAAAAAAAFZc\/mJT3Swhdb0Y\/s1600-h\/image30.png\"><img loading=\"lazy\" decoding=\"async\" title=\"image\" border=\"0\" alt=\"image\" src=\"http:\/\/lh6.ggpht.com\/-Tvc7hehUo1g\/Tg6s659Y5eI\/AAAAAAAAFZg\/dSS6TZ4mKfg\/image_thumb14.png?imgmax=800\" width=\"623\" height=\"569\" \/><\/a><\/p>\n<p><strong>UPDATE 2011-07-16:<\/strong> Tweaked the steps for a typo as per Arcon\u2019s comment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>http:\/\/blog.mpecsinc.ca\/2011\/07\/sbs-2011-wsus-sql-memory-usage-is-very.html Our destination SBS 2011 has an SQL (S-Q-L) process that was taking up a whopping 5GB of RAM: Since this was a relatively fresh install of SBS 2011 we needed to find out what SQL setup was using so much memory. Open Task Manager \u2013&gt; Processes tab. View \u2013&gt; Choose Columns \u2013&gt; PID, Memory, [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-131","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=131"}],"version-history":[{"count":1,"href":"http:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts\/131\/revisions"}],"predecessor-version":[{"id":777,"href":"http:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts\/131\/revisions\/777"}],"wp:attachment":[{"href":"http:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}