none
Reporting Services 2008 R2 ReportingServicesService.exe high CPU

    Question

  • I've had a couple of instances where ReportingServicesService.exe is setting at > 50% of CPU.

    I've looked run the following query but nothing stands out.

    Use  ReportServer
    Go

    select * from ExecutionLog2 order by TimeStart DESC

    Any suggestions for identifying the cause or putting something in place to monitor CPU usage?

    Thanks


    Kevin

    Friday, July 26, 2013 9:37 PM

Answers

  • Hi Kevin,

    The issue can occur due to various factors. You can check the Reporting Services Log file (<drive>:\Program Files\Microsoft SQL Server\MSRS10_50.<InstanceName>\Reporting Services\LogFiles) to see if there are any errors.  

    Here, I suggest that check the version of the C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\mscorwks.dll file. If it is a old version of mscorwks.dll, we can apply the following fix:

    FIX: The CPU usage increases significantly when you run a .NET Framework 2.0-based Multi-AppDomain application that uses objects whose finalizers start ThreadPool methods
    http://support.microsoft.com/kb/971988/en-us

    In addition, the fix has been superseded with the hotfix KB981574 (http://support.microsoft.com/kb/981574/en-us)

    Regards,


    Mike Yin
    TechNet Community Support

    Thursday, August 01, 2013 3:44 PM
    Moderator

All replies

  • If I go into Process Explorer, select ReportingServicesService.exe, select Properties, go to Threads tab, and select one of the threads and click Stack I see this.

    ntoskrnl.exe!IoIs32bitProcess+0x25
    ntoskrnl.exe!FsRtlAddBaseMcbEntry+0x82
    ntoskrnl.exe!FsRtlInsertPerStreamContext+0x48e
    ntoskrnl.exe!snwprintf+0x1c
    ntoskrnl.exe!KeInitializeQueue+0x3b
    ntoskrnl.exe!KeDelayExecutionThread+0x1e7
    ntoskrnl.exe!FsRtlInsertPerStreamContext+0x48e
    ntoskrnl.exe!SePrivilegeObjectAuditAlarm+0x266f
    ntoskrnl.exe!MmFreeContiguousMemory+0x90d
    ntdll.dll+0x3047a
    kernel32.dll+0x304ef

    Does this have any clues?

    The State of many of these threads is "Wait:User Request"


    Kevin

    Friday, July 26, 2013 10:19 PM
  • Hi Kevin,

    The issue can occur due to various factors. You can check the Reporting Services Log file (<drive>:\Program Files\Microsoft SQL Server\MSRS10_50.<InstanceName>\Reporting Services\LogFiles) to see if there are any errors.  

    Here, I suggest that check the version of the C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\mscorwks.dll file. If it is a old version of mscorwks.dll, we can apply the following fix:

    FIX: The CPU usage increases significantly when you run a .NET Framework 2.0-based Multi-AppDomain application that uses objects whose finalizers start ThreadPool methods
    http://support.microsoft.com/kb/971988/en-us

    In addition, the fix has been superseded with the hotfix KB981574 (http://support.microsoft.com/kb/981574/en-us)

    Regards,


    Mike Yin
    TechNet Community Support

    Thursday, August 01, 2013 3:44 PM
    Moderator
  • Hi Mike,

    Thanks for the reply.  I checked the mscorwks.dll and the version installed is 2.0.50727.3643 and is older than the version in hotfix 981574.

    I would just go ahead and install it but the issue described by 981574 does not seem to apply to us since we don't use PowerPivot.

    Can you tell me if there is any potential problem or downside with installing a newer version or should I just go ahead and install it?


    Kevin

    Tuesday, August 06, 2013 5:38 PM