Slow Update Approval

We are currently in the process of addressing some of the performance issues in this area. The steps below would fix part of the performance problems you
are facing. Please try these on your server and let us know if it solves the timeout issues.

1) Save addDeploymentIndex.sql to disk on the Windows Server Update Services (WSUS) server
2) As administrator, run the following command.
 osql -E -S -n -b -i addDeploymentIndex.sql

The osql utility can be found in under the Program Files\Update Services\Tools folder.

Content of addDeploymentIndex.sql:

--------------------8<----------------------
USE SUSDB
GO
BEGIN TRAN
IF NOT EXISTS (SELECT * FROM sysindexes where name='nc7DeploymentRevision')
BEGIN
     CREATE NONCLUSTERED INDEX nc7DeploymentRevision ON dbo.tbDeployment(RevisionID, TargetGroupID, ActionID)
END
COMMIT TRAN
GO
--------------------8<----------------------

Note that the text starting with "CREATE NONCLUSTERED " between the
BEGIN
    ...
END block needs to be one single long line.

If the WSUS server database (SUSDB) is not on the default SQL server instance on the machine, It is probably on a named instance. Look at the following registry key to find out which SQL server/MSDE server you have to run the command at.

HKLM\SOFTWARE\Microsoft\Update Services\Server\Setup\SqlServerName

You can replace the value of this key for the place holder in the command below.