A plan for the software update point infrastructure is essential before you use software updates in a System Center Configuration Manager production environment. WSUS hangs on Cleanup wizard for Unused Updates, then disconnects from console. It does not run much better when written without a CURSOR. I modified it to use a WHILE loop and it deletes about 1 per minute here which is the same as the old code with a CURSOR. WSUS-report-console.png' alt='How To Remove Approved Updates From Wsus Registry' title='How To Remove Approved Updates From Wsus Registry' />Not surprised. To be frank, using a WHILE LOOP just turns it into a manual CURSOR, making it no better off than using the CURSOR construct in T SQL. The correct approach here is to write the code with a SET BASED approach. Unfortunately, as youre about. In order to use the set based approach, youll need to take the code from sp. Delete. Update and modify it to join directly to the table of GUIDs to delete. Execute the whole thing in oneDELETE statement. Of course, part of the other problem that contributes to the performance issues is that sp. Delete. Update LSOuses CURSORs. Delete. Update retrieves a list of Revision. IDs, and then calls sp. Delete. Revision for each of those. Revision. IDs. And as weve already seen, some updates may have a large number of Revision. IDs. sp. Delete. Revision is where the real work is done. At the crux of that proc, are deletes from these tables dbo. Event. Instance this will be a time killer as well, depending on how many clients affected a given update, and how much activity surrounded that updatedbo. Deploymentdbo. tb. Update. Status. Per. Computerdbo. tb. Propertydbo. Flattended. Revision. In. Categorydbo. tb. Revision. In. Categorydbo. Revision. Languagedbo. More. Info. URLFor. Aplikasi Download Video Dari Blog. Revisiondbo. tb. Security. Bulletin. For. Revisiondbo. KBArticle. For. Revisiondbo. Bundle. Dependencydbo. Bundle. At. Least. Onedbo. tb. Bundle. Alldbo. tb. Prerequisite. Dependencydbo. tb. Installed. Update. There are multiple posts online, discuss about how to uninstall Windows updates if something goes wrong with deployed patches, but I did not find anything. I had a situation where WSUS was failing to download updates after moving content from one local drive to another. I thought resetting might fix it but it didnt. How To Remove Approved Updates From Wsus DownloadSufficient. For. Prerequisitedbo. Prerequisite. And all of the associated transaction wrappers and error checking for each and every deleted row from each of those tables to ensure continued data integrity in the database. So while the code above making a simple call to sp. Pembahasan Soal Ujian Nasional Smp 2014 on this page. Delete. Update looks quite simple on the surface. LOT of activity going on to make that one update get deleted. If you wanted to speed it up. Get. Obsolete. Updatesto. Cleanup to get a list of Update. IDs, then build a list of Revision. IDs from that, and then join that temp table of Revision. IDs to each of the 1. Which would force all of those deleted records into a SINGLE transaction, and probably whatever gains you got from switching from procedural logic to set based logic would be lost in the massive overhead of managing a transaction of. A possible compromise would be to execute a set based DELETE by Update. ID, so youd capture the Revision. IDs for a given Update. ID, and then delete across all 1. Revision. IDs except where that list aint so short. But still. this compromise might well speed things up, as the loop for Update. IDs is likely only measured in the hundreds, where as the loop through all Revision. IDs is sometimes measured in the thousands or tens of thousands depending on ifwhen the server was last purged. Lawrence Garvin, M. S., MCSA, MCITP EA, MCDBASolar. Winds Head Geek. Microsoft MVP Software Packaging, Deployment Servicing 2. My MVP Profile http mvp. Lawrence2. 0R2. Garvin 3. The views expressed on this post are mine and do not necessarily reflect the views of Solar. How to Clear Out Your WSUSContent Folder. Today I had an interesting issue where a particular servers WSUSContent folder increased in size incredibly quickly to the point where the logical disk it was hosted on ran out of space. This server was running Windows Server 2. There is a handy utility, WSUSUtil. IT administrators to reset the WSUS components and rechecks each update in the database, verifying the content is present in the WSUSContent folder and downloads it again if necessary from Microsoft. Although this allows you to set a clean slate for WSUS, there must be a reason why your WSUSContent folder increased in size so quickly in the first place. Its important to find this out before doing any reset, or else you will be needlessly re downloading the exact same data again. What to Check. Update Files Languages This should be the first port of call. Ensure you are downloading only the updates your network needs. If you had a setting selected before but turned it off at a later date such as All Languages instead of just English, they will still be present in the WSUSContent folder there is no automatic deletion process. WSUS Downstream Servers Ensure that the downstream servers are configured correctly remember settings set here can also affect what your upstream WSUS server downloads, even if the settings between the servers are different. Download Files Only When Updates are Approved In an ideal world, IT admins should always test updates before rolling out onto client computers. If this option in WSUS is not checked, then all updates that are synced are downloaded. Of course you then need to approve any applicable updates after setting this. Even with the correct settings applied, WSUS can have many GBs of data stored. The Server Cleanup Wizard can help as it does offer to delete any expired updates, but it doesnt perform all the magic thats required. I Found My Issue How Do You Do a Reset Correct any settings above or disapprove any unneeded updates. Close any open WSUS consoles on that server for all sessions currently logged on. Go to Administrative Tools Services or run services. STOP the Update Services service. In Windows Explorer browse to the WSUSContent folder typically D WSUSWSUSContent or C WSUSWSUSContentDelete ALL the files and folders in the WSUSContent folder. Go to Administrative Tools Services or run services. START the Update Services service. Open a command prompt and navigate to the folder C Program FilesUpdate ServicesTools. Run the command WSUSUtil. RESETAs you are downloading a lot of updates again, it can take a few hours for the process to fully complete be patient How do you tell when the process is complete You can check by ensuring the WSUSContent folder is not growing, or you can check the Software. Distribution. log, which is located C Program FilesUpdate ServicesLog. FilesSoftware. Distribution. When you start the reset command, you should see a line towards the bottom of the log similar to this Wsus. Service. 1. 3  Execution. Context. run. Try. Code     State Machine Reset Agent Starting. After waiting for some time, check the log again and search for the text State Machine Reset Agent FinishedWsus. Service. 1. 3  Execution. Context. run. Try. Code     State Machine Reset Agent Finished. I hope this has helped you Any questions, just drop a comment below.