Microsoft KB Archive/905622

= You experience poor performance when you run reports if the &quot;Auto close&quot; option is enabled for the ReportServerTempDB database in SQL Server 2000 Reporting Services =

Article ID: 905622

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Reporting Services

-





SYMPTOMS
Consider the following scenario. In Microsoft SQL Server 2000 Reporting Services, the Auto close option is enabled when the ReportServerTempDB database is created. In this scenario, you experience poor performance when you run reports.

By default, the Auto Close option is only enabled in Microsoft SQL Server 2000 Personal Edition.



CAUSE
This problem occurs because SQL Server Reporting Services never creates connections to the ReportServerTempDB database. Instead, SQL Server Reporting Services uses the ReportServerTempDB database from the joins of the stored procedures. Therefore, the ReportServerTempDB is constantly unloaded. During the loading time, you notice times when 0 percent CPU utilization occurs and no work is performed. When the server is under heavy load, you experience poor performance.



RESOLUTION
To resolve this problem, click to clear the Auto close check box in the properties for the ReportServer database and the ReportServerTempDB database.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
When the Auto Close option is enabled, the database is closed and unloaded when the following conditions are true:
 * The last user of the database disconnects from the database.
 * All processes in the database are completed.

Keywords: kbreport kbperformance kbtshoot kbprb KB905622

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.