SQL Server Reporting Services may stop responding for several minutes on an x64-based computer in SQL Server 2005, 64-bit version (909804)


The information in this article applies to:

  • Microsoft SQL Server 2005 Reporting Services
Bug #: 406577 (SQLBUDT)

SYMPTOMS

In Microsoft SQL Server 2005, 64-bit version, SQL Server Reporting Services may stop responding for several minutes. This issue occurs if you are using SQL Server Reporting Services on an x64-based computer and you have installed less than 1.5 gigabytes (GB) of memory for each virtual CPU. During this time, you may notice one or more of the following issues:
  • Low CPU utilization occurs.
  • In the Performance Monitor tool (Perfmon.exe), the value of the Private Bytes performance counter for the W3wp.exe worker process of Microsoft Internet Information Services (IIS) 6.0 is noticeably larger than the amount of physical memory on the computer.
  • You cannot resolve the issue by restarting the IIS service.

CAUSE

This issue occurs because Reporting Services is paused. Reporting Services is waiting for the x64 version of the garbage collector in the Microsoft .NET Framework 2.0 to perform a collection.

In certain situations, the garbage collector does not collect unused resources in a timely manner. The garbage collector may collect unused resources after lots of collectable objects are written to the Microsoft Windows paging file (Pagefile.sys). Sometime after these objects are written to the paging file, Reporting Services stops responding. This behavior occurs when the garbage collector starts to collect these unused resources.

RESOLUTION

To resolve this issue, make sure that you have installed at least 1.5 GB of memory for each virtual CPU.

WORKAROUND

You can temporarily work around this issue by using one of the following methods:
  • Wait until the garbage collector has finished collecting the unused resources. This process may take several minutes.
  • Restart the computer.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MajorLast Reviewed:11/18/2005
Keywords:kbExpertiseAdvanced kbsql2005rs kbbug KB909804 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.