Keeping Your WSUS Database Alive With WSUSDBMaintenance T-SQL Script
Large WSUS deployments will have their performance degrade over time if the WSUS database is not maintained properly. The WSUSDBMaintenance script is a T-SQL script that can be run by SQL Server administrators to re-index and defragment the WSUS database.
Download At Source
Source: Bink.nu | WSUSDBMaintenance T-SQL Script
With the implementation of WSUS into SCCM 2007 this will become an important task. I have heard from a number of customers that they used WSUS and it was fine for a couple months and then the database just stopped working. So they stopped using it because it was too much work to maintain. Hopefully this may alleviate that issue.
Regards,
Anthony
Anthony Clendenen | Senior Technical Consultant | Microsoft Practices | Dimension Data
“Dimension Data is Microsoft’s 2006 Global Advanced Infrastructure Technology Innovation
Partner of the Year… for the Dynamic Desktop Deployment Solution”
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }
Trackbacks
No Trackbacks
Comments
No Comments
