Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sergey_B
Starting Member
2 Posts |
 Posted - 2011-03-28 : 14:17:04
|
| 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? |
|
|
|
|
|
SSRS report is slower on 64bit server than 32bit