I'm the volunteer IT admin at a small school. We have SBS 2003 with about ten desktops. The server performance report is emailed to me daily. It is setup with a wizard in the Monitoring and Performance part of the "Server Management" console.

It often fails with a "The page cannot be displayed" error.

The event log shows

Event Type: Error
Event Source:   ServerStatusReports
Event Category: None
Event ID:   1
Date:       1/16/2011
Time:       6:03:14 AM
User:       N/A
Computer:   ALPHA
Description:
Server Status Report:
    URL:        http://localhost/monitoring/perf.aspx?reportMode=1&allHours=1
    Error Message:  Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    Stack Trace:       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
[plus lots more stack trace]

This has been happening for years :) I've never really solved it. It seems to be related to WSUS. When it happens, I run the Update Services "Server Cleanup Wizard". That takes a long time to run. If I haven't run it for a while it can take 10 hours. I also run the WsusDBMaintenance.sql script (from TechNet I think) which reindexes the database etc. Those two things seem to get it working again for a while. Recently the "while" has become a couple of weeks.

My searching online has revealed lots of people having this problem but no real solution.

Does anyone have any good ideas about this? I have to wonder if something in the WSUS SQL schema is not indexed properly. The time that the server cleanup wizard takes seems ridiculous.

Thanks