Thanks Jo! From what I understand from Microsoft documentation, SSRS 2017 and newer is significantly different from SSRS 2016 (it's a separate installer vs being included in the SQL server...

• This reply was modified 4 months, 2 weeks ago by  agerard 65681.

SSRS RDLs are definitely a bit quirky and difficult to master but they are extremely flexible. I use Visual Studio 2017 to design RDLs and would recommend that over the...

in our situation, we wait for external data to be refreshed, we start our ETL and dataset processing as soon as it's done, and then trigger the schedules that call...

Thanks for your reply Parker! I appreciate it.

The business goal is to send these reports out ASAP. If we were to break the data-driven subscriptions into smaller pieces, we'd be...

Thanks much for the answer, Jeff! But interestingly, that seems low. There is one query against a table which is about 700MB in size and where there is no covering...

Is that what the "read" column on a sql profiler trace is showing? Appears it may be... sorry for the dumb question then! 😉

We implemented a workaround. can i delete this "malfunctioning" subscription from the subscriptions table?

Thanks Sue.

The change was made via the web front end. Someone made a change to the SQL script in the data driven subscription.

The stack dump above...

yes we've already adjusted CPU count and max queue threads settings while measuring performance data. i'm looking specifically to not have a few reports with a large number of subscriptions...

In the SQL Reporting Service Database you will find a table called Subscriptions, and in that table an ntext field called ExtensionSettings. This is where the messages are stored (as...

Yeah, this is not possible from what I know. I believe Sue_H's suggestion above is the best way to go. I use subscriptions that write to a file share, they're...

We have 16GB of RAM on the machine and there doesn't appear to be memory pressure. I'm not sure about "high-performance mode", I don't know that that's a setting on...

Thanks Jo

We have gone past the usefulness of the MaxQueueThreads setting. It's currently set higher than the default, but we're not reaching anywhere near the number of threads...

I may have solved my own problem. Apparently I needed to include a header row (even though it's not a header row).

Thanks for the answers folks. Looks like the Enterprise licenses would be by far the largest piece of the total cost of scaling out the system...