You experience poor performance when you run reports if the "Auto close" option is enabled for the ReportServerTempDB database in SQL Server 2000 Reporting Services (905622)


The information in this article 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 "Applies to" 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.
Modification Type:MajorLast Reviewed:9/16/2005
Keywords:kbReport kbPerformance kbtshoot kbprb KB905622 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.