SQL Server Performance

SSRS report is slower on 64bit server than on 32bit

Discussion in 'SQL Server 2008 Reporting Services' started by Sergey_B, Mar 28, 2011.

  1. Sergey_B New Member

    I am facing following issue with SSRS performance. Looks like reports run slower on 64bit server than they do on 32bit one. See comparison below:
    Report on 32bit server:
    · PC: Windows 7, 1 CPU, 4GB RAM
    · SQL Server: Microsoft SQL Server 2008 (SP2) - 10.0.4266.0 (Intel X86) Nov 6 2010 12:40:17 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition on Windows NT 6.1 <X86> (Build 7600: )
    · Number of records: 989634
    · TimeDataRetrieval: 5-11 sec
    · TimeProcessing: 338-370 sec
    · TimeRendering: 0 sec
    The same report on 64bit server:
    · PC: Windows Server 2008, 2 CPU, 4GB RAM
    · SQL Server: Microsoft SQL Server 2008 (SP2) - 10.0.4266.0 (X64) Nov 5 2010 16:11:39 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2
    · Number of records: 989634
    · TimeDataRetrieval: 33-83 sec
    · TimeProcessing: 612-667 sec
    · TimeRendering: 22-45 sec
    When monitoring memory usage by SSRS, I can see that on 32bit machine it only uses about 3GB, while on 64bit it uses about 7GB, even though there is only 4GB physical RAM on the server. Probably this is the reason of performance degradation, but I don’t know how to configure SSRS to use only available physical RAM.
    Do you have any ideas how to resolve this issue?
  2. satya Moderator

    Are you able to capture the memory, CPU, Disk related counters when the X64 SSRS is functioning. I believe the initial stats that you have obtained are from Task Manager.
    I would also recommend the MSDN article http://msdn.microsoft.com/en-us/library/ms159206.aspx about setting up memory settings for SSRS. It also depends on the number of concurrent connections, the database and see the technical notes on http://sqlcat.com/technicalnotes/ar...rting-services-performance-optimizations.aspx optimization best practices.

Share This Page