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 |
|
ade_mcfade
Starting Member
2 Posts |
 Posted - 2009-06-23 : 04:56:31
|
| Hi, We've been upscaling one of out servers to take on more processing, to do this we went from a dual core to a quad core processor. The box runs SQL 2005, IIS and Reporting Services. The database is fineThe website runs like a dreamReporting services is so slow, its painfulOpening reporting services can take 2-5 minutes, most actual reports time out. We then removed the QUAD and put the DUAL back, Reporting Services then worked a treat. Any ideas why this may be and any potential solutions would be greatfully recieved. Cheers |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-23 : 05:19:41
|
Seems like an issue for Microsoft Product Services.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-23 : 05:21:44
|
http://sqlcat.com/technicalnotes/archive/2008/07/09/scaling-up-reporting-services-2008-vs-reporting-services-2005-lessons-learned.aspx
E 12°55'05.63"N 56°04'39.26" |
|
|
|
ade_mcfade
Starting Member
2 Posts |
Posted - 2009-06-23 : 10:27:28
|
| cheers folks - much appreciated. |
|
|
|
|
|
|
Quad-Core kills Reporting Services