Microsoft KB Archive/909804

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

Article ID: 909804

Article Last Modified on 11/18/2005

-

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 &quot;Applies to&quot; section.

Keywords: kbbug kbexpertiseadvanced kbsql2005rs KB909804

-

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

© Microsoft Corporation. All rights reserved.