Sunday, March 25, 2012

Connection Pooling for Data-Driven Subscriptions?

Is there any way to get a data-driven subscription to share the DB
Connection between iterrations?
The behaviour we're seeing currently is a new connection being opened/closed
for each report delivered by our data-driven subscription. This is impacting
our server perf.
Suggestions? Pointers?
Did I miss anything in the docs?
TIAAre they all using the same credentials?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Paul Enfield" <penfield@.paraport.com> wrote in message
news:uFipWYyVFHA.3588@.TK2MSFTNGP10.phx.gbl...
> Is there any way to get a data-driven subscription to share the DB
> Connection between iterrations?
> The behaviour we're seeing currently is a new connection being
opened/closed
> for each report delivered by our data-driven subscription. This is
impacting
> our server perf.
> Suggestions? Pointers?
> Did I miss anything in the docs?
> TIA
>

No comments:

Post a Comment