How to re-index WSUS database
Monthly re-indexing of WSUS database is a recommended task to maintain its performance. You can use WsusDBMaintenance script to reindex any version of the WSUS database, SQL Server or Windows Internal Database.
If you are using Windows Internal Database for the WSUS database, you’ll need to use the sqlcmd utility.
You can easily install sqlcmd util without having SQL setup media. To do this
Then visit http://gallery.technet.microsoft.com/scriptcenter/6f8cde49-5c52-4abd-9820-f1d270ddea61 to obtain WsusDBMaintenance script. You can easily use the copy code button and paste clipboard into a new text document then rename it to WsusDBMaintenance.sql
To run Re-index
Run the command below, my sqlcmd is located under (I used the installation method above)C:Program FilesMicrosoft SQL Server90Toolsbinn folder if you have already have it please use appropriate path. And I also chose C:Program FilesUpdate ServicesDatabase folder for my WsusDBMaintenance.sql file, it is completely up to you.
sqlcmd -I -S \.pipeMSSQL$MICROSOFT##SSEEsqlquery -i “C:Program FilesUpdate ServicesDatabaseWsusDBMaintenance.sql”