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

Report is taking long time to run on report manager. Expand / Collapse
Author
Message
Posted Monday, November 07, 2011 12:06 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 11:38 AM
Points: 80, Visits: 357
Hello,

One report is running fine in BIDS and taking some seconds in BIDS. BUT it is taking very long time on report manager and failing. Can you tell me what is the reason? OR how to fix this.

Thank you,
BMR
Post #1201631
Posted Wednesday, November 16, 2011 3:29 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 26, 2012 1:44 PM
Points: 25, Visits: 84
Is there any particular message you get when it fails? May be stupid question but does the hosted server has enough capacity to handle reports?
Post #1206512
Posted Wednesday, November 16, 2011 7:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:16 PM
Points: 2,812, Visits: 2,543
Take a look through the trace files for more information.
Post #1206688
Posted Wednesday, November 16, 2011 3:22 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, February 24, 2014 6:09 AM
Points: 827, Visits: 1,360
Just out of experience: Are you running the reports against the same database/cube, with the exact same parameters? It is easy to overlook some slight differences in the parameters, which can drastically change the performance.



Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL
Post #1207174
Posted Wednesday, November 16, 2011 3:33 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 11:38 AM
Points: 80, Visits: 357
Thanks for reply. It is a database issue.
Post #1207176
Posted Saturday, June 01, 2013 3:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 24, 2014 3:53 AM
Points: 4, Visits: 22
Hi,

May i know that database issue.....i am also facing the same issue not able to view report in report manager..

Thanks
Post #1458932
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse