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
>
Sunday, March 25, 2012
Connection Pooling for Data-Driven Subscriptions?
Labels:
behaviour,
connection,
data-driven,
database,
iterrations,
microsoft,
mysql,
oracle,
pooling,
server,
share,
sql,
subscription,
subscriptions
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment