Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS blocks up the whole SQL2005 server Expand / Collapse
Author
Message
Posted Tuesday, August 7, 2012 3:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 24, 2014 7:22 AM
Points: 182, Visits: 155
Hi guys,
I have an subscription that normally runs in the evening. 84 reports are built by this subscription. It's done after 15 minutes. O.k. there are a lot of SQL's and MDX's in that report. But when it excepionally runs in the morning, when cubes are built at the same time, this subscription blocks up the whole server. After more than an hour status is still "0 of 84 processed; 0 errors." And the cube processing is very much slower also. Any idea?
regards
Ralf
Post #1341084
Posted Wednesday, August 8, 2012 12:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:03 PM
Points: 7, Visits: 174
It may be that your reports cannot query the data until the cubes have completed processing...
Post #1342095
Posted Thursday, August 9, 2012 12:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 24, 2014 7:22 AM
Points: 182, Visits: 155
the cube that is read by the report is already loaded at that time. but other cubes are beeing loaded at the same time. regards Ralf
Post #1342423
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse