monitoring connections and pooling

Hi
I have a problem with an aspnet app taking >30 seconds to
open a connection to a sql server.
Which tools could I use to monitor what connections are
open/available in the pool?
Are there any references/articles recommended using these?
Thanks
AdamIf you use OLE DB, I don't think there are any MS tools to
monitor the session pooling. If you use ODBC, you can enable
the counters for Perf Mon by following the steps in this
article:
How to Enable ODBC Connection Pooling Performance Counters
http://support.microsoft.com?id=216950
-Sue
On Wed, 13 Aug 2003 20:55:01 -0700, "adam" <adam@.twv.org>
wrote:
>Hi
>I have a problem with an aspnet app taking >30 seconds to
>open a connection to a sql server.
>Which tools could I use to monitor what connections are
>open/available in the pool?
>Are there any references/articles recommended using these?
>Thanks
>Adam|||Unfortunately I am using OLEDB from a C# web app
>--Original Message--
>If you use OLE DB, I don't think there are any MS tools
to
>monitor the session pooling. If you use ODBC, you can
enable
>the counters for Perf Mon by following the steps in this
>article:
>How to Enable ODBC Connection Pooling Performance
Counters
>http://support.microsoft.com?id=216950
>-Sue
>On Wed, 13 Aug 2003 20:55:01 -0700, "adam" <adam@.twv.org>
>wrote:
>>Hi
>>I have a problem with an aspnet app taking >30 seconds
to
>>open a connection to a sql server.
>>Which tools could I use to monitor what connections are
>>open/available in the pool?
>>Are there any references/articles recommended using
these?
>>Thanks
>>Adam
>.
>|||The problem seems to be that if a connection is request
within 2-3 minutes of the previous one, it is returned
instantly (presumably from the pool). But if it has been
more than this time, it takes 30 seconds to get one. I am
assured that the SqlServer cluster is not overloaded and
none of the other apps accessing it are having problems.
When run the same timing code on my development laptop it
obtains a connection (from a sqlserver on the same box)
in 0ms. When the same laptop tries to get one from the
production SqlServer, it takes about 32s, which leads me
to think it is a problem with the production server.
At the moment I have had to hack it so that the web app
makes a small request to the webserver every 2 mins, just
to keep a connection in the pool, so at least there is
always one connection available quickly, but this is
clearly not ideal.
How can I further elucidate the nature of this problem,
and why the server is taking so long to return a
connection.
Adam
>Hi
>I have a problem with an aspnet app taking >30 seconds
to
>open a connection to a sql server.
>
>Adam
>.
>