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 Subscriptions failure Expand / Collapse
Author
Message
Posted Thursday, July 25, 2013 11:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 24, 2014 3:42 PM
Points: 60, Visits: 241
Hi All,
We have a data driven subscription that would email a report to 40 users. It is scheduled to run every morning at 7:45 am. The report runs pretty quick when it is run manually(takes hardly 10 secs), however the subscription fails for few users. We had some issues with RS around 8-9 am this morning and when we checked the cpu utilization it was 100% and our dba told that this report is taking almost all of the cpu thus causing the reporting servcies to run slow. Any ideas of how to fix this. Attahced file shows how the subscription was successful for few users and failed for few users.
Post #1477654
Posted Friday, July 26, 2013 6:51 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, December 12, 2014 6:22 AM
Points: 531, Visits: 449
I'm not seeing an attachment.

What is the failure message saying? What is the dba looking at that suggests this one report is taking all the cpu?
Post #1477977
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse