{"id":121,"date":"2014-05-12T16:09:24","date_gmt":"2014-05-12T16:09:24","guid":{"rendered":"http:\/\/www.torontohelpdesk.ca\/blog\/?p=121"},"modified":"2014-05-14T18:45:34","modified_gmt":"2014-05-14T18:45:34","slug":"cleaning-up-wsus","status":"publish","type":"post","link":"https:\/\/www.torontohelpdesk.ca\/blog\/cleaning-up-wsus\/","title":{"rendered":"Cleaning up WSUS"},"content":{"rendered":"<p><strong>Problem:<\/strong><\/p>\n<p>WSUS is big and full and not happy with you. When you run the WSUS Server Cleanup Wizard, it crashes&gt;<\/p>\n<p><strong>Answer:<\/strong><\/p>\n<p>(h\/t <a href=\"http:\/\/social.technet.microsoft.com\/Forums\/windowsserver\/en-US\/487ec289-9d75-4fba-8bc8-af50cee231cb\/susdbmdf-file-too-big-on-a-windows-sbs-2008-server?forum=winserverwsus\" target=\"_blank\">Lawrence Garvin<\/a>)<\/p>\n<p>This post has been edited for spacing and my notes.<\/p>\n<p>Decline any\u00a0unneeded updates &#8212; this likely will include several thousand Definition Updates. &#8220;Unneeded&#8221; is defined as any update reported as &#8220;100% Installed\/NotApplicable&#8221; and superseded.<\/p>\n<p><span style=\"color: #333399;\">Run the Server Cleanup Wizard to delete expired updates and old revisions. (This may take multiple runs if the SCW times out performing the task, just restart the SCW and let it run some more)<\/span><\/p>\n<p class=\"date\">(h\/t <a href=\"http:\/\/bartvdw.wordpress.com\/2010\/03\/07\/decline-superseded-updates-in-wsus\/\" target=\"_blank\">Bart<\/a>)<\/p>\n<p>Although you can use the server cleanup wizard, you may want from time to time to clean manually all superseded updates to clean your WSUS infrastructure.<\/p>\n<p>The trick here is to have the column \u2018Supersedence\u2019 is visible. Open WSUS console and go to \u2018All Updates\u2019. Enable the \u2018Supersedence\u2019 column.<\/p>\n<p><a href=\"http:\/\/bartvdw.files.wordpress.com\/2010\/03\/image8.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border-width: 0;\" title=\"image8\" src=\"http:\/\/bartvdw.files.wordpress.com\/2010\/03\/image8_thumb.png?w=62&amp;h=81\" alt=\"image8\" width=\"62\" height=\"81\" border=\"0\" \/><\/a><\/p>\n<p>Now there are 4 options:<\/p>\n<ul>\n<li>No icon: update doesn\u2019t supersede another one nor is it superseded by an update<\/li>\n<li>\u00a0<a href=\"http:\/\/bartvdw.files.wordpress.com\/2010\/03\/image11.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border-width: 0;\" title=\"image11\" src=\"http:\/\/bartvdw.files.wordpress.com\/2010\/03\/image11_thumb.png?w=23&amp;h=23\" alt=\"image11\" width=\"23\" height=\"23\" border=\"0\" \/><\/a> Blue square on top: this update supersedes another update, these updates you do not want to clean\u2026!!<\/li>\n<li>\u00a0<a href=\"http:\/\/bartvdw.files.wordpress.com\/2010\/03\/image14.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border-width: 0;\" title=\"image14\" src=\"http:\/\/bartvdw.files.wordpress.com\/2010\/03\/image14_thumb.png?w=23&amp;h=23\" alt=\"image14\" width=\"23\" height=\"23\" border=\"0\" \/><\/a> Blue square in the middle: this update has been superseded by another update, and superseded another update as well, this is an example of an update you may want to clean (decline)<\/li>\n<li>\u00a0<a href=\"http:\/\/bartvdw.files.wordpress.com\/2010\/03\/image17.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: inline; border-width: 0;\" title=\"image17\" src=\"http:\/\/bartvdw.files.wordpress.com\/2010\/03\/image17_thumb.png?w=22&amp;h=24\" alt=\"image17\" width=\"22\" height=\"24\" border=\"0\" \/><\/a> Blue square in the right below corner: this update has been superseded by another update, this is an example of an update you may want to clean (decline)<\/li>\n<\/ul>\n<p><strong><em><span style=\"text-decoration: underline;\">Note:<\/span><\/em><\/strong> Always verify that all superseding updates are approved before doing this operation!<\/p>\n<p><span style=\"color: #333399;\">Run the Server Cleanup Wizard a 2nd time to delete files freed up by the thousands of updates that were declined in Step #1.<\/span><\/p>\n<p><span style=\"color: #333399;\">Verify that the Client Detection Frequency is in a reasonable range. (Anything less than six hours is pointless.)<\/span><\/p>\n<p><span style=\"color: #333399;\">Manually delete any computers in All Computers that are not operational. (The Server Cleanup Wizard can do this for machines out-of-service more than 30 days, but in an SBS environment where you probably know every client system by sight, it might be better to visually verify what&#8217;s there and what ought not be.)<\/span><\/p>\n<p><span style=\"color: #333399;\">Using SQL Server Management Studio, inspect the actual amount of data storage consumed by the data, and compare that to the physical side of the MDF file. If the actual data consumption is less than 80% of the physical database file size, you may get some benefit from shrinking the database file. If there&#8217;s &lt;20% free space, though, it&#8217;s not worth the effort.<\/span><\/p>\n<p>If you can&#8217;t see the database, SQL Management Studio Express, put in <strong><a>\\\\.\\pipe\\MSSQL$MICROSOFT##SSEE\\sql\\query<\/a><\/strong> as the Server Name.<\/p>\n<p><span style=\"color: #333399;\">After shrinking the database, if applicable, stop the SQL Server service hosting the WSUS database and defragment the filesystem hosting the WSUS database.<\/span><br \/>\n<span style=\"color: #333399;\">Restart the SQL Server service and run the WSUS DB Maintenance utility to reindex the database and recalculate table statistics.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Problem: WSUS is big and full and not happy with you. When you run the WSUS Server Cleanup Wizard, it crashes&gt; Answer: (h\/t Lawrence Garvin) This post has been edited for spacing and my notes. Decline any\u00a0unneeded updates &#8212; this <a class=\"more-link\" href=\"https:\/\/www.torontohelpdesk.ca\/blog\/cleaning-up-wsus\/\">Continue reading <span class=\"screen-reader-text\">  Cleaning up WSUS<\/span><span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[81],"tags":[],"class_list":["post-121","post","type-post","status-publish","format-standard","hentry","category-wsus"],"_links":{"self":[{"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/posts\/121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/comments?post=121"}],"version-history":[{"count":3,"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/posts\/121\/revisions"}],"predecessor-version":[{"id":125,"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/posts\/121\/revisions\/125"}],"wp:attachment":[{"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/media?parent=121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/categories?post=121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/tags?post=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}