rob wrote:
> A few times a day we get a dramatic increase in the number of user
> connections on our database (sometimes 4 to 5 times as many according
> to perfmon). Here is some additional information...
>
> - from the time the number of connections starts to increase to the
> time it drops back down to a "normal" level can take anywhere between 1
> minute and 60 minutes
> - the increase usually occurs rather quickly and drops off slowly
> - we've checked for blocking, and none occurs during these sudden
> increases
> - we've ran profiler, and it seems like the average duration of queries
> during these periods are no different then at other times of the day
>
> Any ideas how we can find out what is causing this sudden increase in
> user connections? Your help is greatly appreciated.