Running multiple subscriptions at same time

Question

Running multiple subscriptions at same time

markmeiller

SSC-Addicted

Points: 446
More actions
January 12, 2010 at 9:38 am

#386082

The other day we had a data driven subscription run all day. The subscription it’s self ran fine because it send out around 5k reports to many different users, but while it was executing it blocked the execution of all of our other subscriptions until it was complete. So basically I want to know how to give ssrs extra threads for subscriptions so this won’t happen again.
I remember reading once that ssrs assigns threads to subscriptions on an as needed bases, meaning that if you manager to overwhelm the server it will add new threads but I have never been able to actually make it do this. Unfortunately I can’t seam to find that documentation or for that mater any other documentation on the subject of running multiple subscriptions at the same time.
Thanks in advance for your responses.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

You did not find any documentation because none exist your problem is actually related to CDO the COM dll used for Subscription which run without issues when IIS was used because IIS comes with SMTP which is the mail protocol. Now that SSRS deploys in the filesystem I think Windows puts your mail in a queque. You have two options create an unattended execution account or enable your IIS SMPT and use it to pass the mail to your exchange. The reason web applications send hundreds to thousands of mail a day using only Web.Config definition and SSRS is running into issues with a few mails so it is related to the CDO dll. The Asp.net team depreciated it back in 2005 and SQL Server is still using it is the problem.

http://technet.microsoft.com/en-us/library/ms156302.aspx

Kind regards,
Gift Peddie

becklery Hall of Fame Points: 3315 More actions · Answer 2

Hi.

Please refer to the url below:

http://msdn.microsoft.com/en-us/library/ms172911.aspx

I wish it will be helpful.

Regards,

becklery.

RAQ Report: Web-based Excel-like Java reporting tool[/url]

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

becklery (1/14/2010)Hi.
Please refer to the url below:
http://msdn.microsoft.com/en-us/library/ms172911.aspx
I wish it will be helpful.
Regards,
becklery.

I don't know what you smoked but need to stop posting random nonsense to my threads the link you posted is for replication and let me tell you it is compact edition replication not related to SSRS subscription.

Kind regards,
Gift Peddie