|
|
Posted by bjorn.augestad@gmail.com on 07/28/06 14:16
Erland Sommarskog wrote:
> bjorn.augestad@gmail.com (bjorn.augestad@gmail.com) writes:
> > I just sampled all statements for one hour, and we had ~450.000 calls
> > to sp_reset_connection, or 125 calls per second. Seems way too high to
> > me, even if the documentation describes it as lightweight.
>
> Al least connection pooling is working!
More or less.
We also have a tiny ASP app that writes one row to the db for each HTTP
request it receives. The ASP app used to use connection pools with
default settings. After changing Min and Max pool size to 300,
everything is suddenly more normal, now the server is so fast my
profiler traces has to be changed to make them report rows at all :-)
Stuff that used to take between 1200 and 7000ms now finishes in 1ms, so
I guess the problem has been solved.
Have a great weekend.
Bjørn
[snip]
Navigation:
[Reply to this message]
|