How can I monitor open database connections?

[doug]

I need to resolve some issues with a website which is leaving database
connections open, according to the hosting company!

The ASP code is quite extensive, and it's going to be quite a job
trawling through it.

Is is possible to see a count of the open database connections? That
way I could monitor this while using the website, to pinpoint the
pages that are leaving open connections.

Would connection pooling leave open connections, even though they are
closed in code?

Thanks in advance.

Doug

 

[Guest]

You can query the database to see how many active connections
there are. But ASP normally uses connection caching so you would
expect to see the connections count to the ASP connection
cache -- and it sounds like what you want is the number of
connections from your code to the connection cache, not from
the connection cache to the database.
For monitoring the ASP connection cache, you will have to ask
ASP people.

(david)