Pool connections

  • Thread starter Thread starter Bragadiru
  • Start date Start date
B

Bragadiru

Hi,

From time to time, I get an error message : "... all pooled connections were
in use and ... " and I want to check how many connections are opened by my
..NET application. How can I do this ? There is a tool in Sql Server ?
My Ms Sql Server 2000 is on a remote computer (with Small Business Server
2000).

Thanks for any advice or link
 
Hi,

You are probably not closing the connection instances.
Anyway, there are several ways:
- sp_who system stored procedure
- the Profiler tool
- Performance monitor
 
Thank you, Miha !

Does anybody know any "How To" links ?

Thanks again.


Miha Markic said:
Hi,

You are probably not closing the connection instances.
Anyway, there are several ways:
- sp_who system stored procedure
- the Profiler tool
- Performance monitor

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Bragadiru said:
Hi,

From time to time, I get an error message : "... all pooled connections
were
in use and ... " and I want to check how many connections are opened by my
.NET application. How can I do this ? There is a tool in Sql Server ?
My Ms Sql Server 2000 is on a remote computer (with Small Business Server
2000).

Thanks for any advice or link
Click to expand...
Click to expand...
 
Bragadiru,
It is not a how to per se, but I blogged about this here :
http://weblogs.asp.net/angelsb/archive/2004/08/25/220333.aspx

Let me know if you need more information and I will be happy to add it.
--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging about ADO.NET: http://weblogs.asp.net/angelsb/




Bragadiru said:
Thank you, Miha !

Does anybody know any "How To" links ?

Thanks again.


Miha Markic said:
Hi,

You are probably not closing the connection instances.
Anyway, there are several ways:
- sp_who system stored procedure
- the Profiler tool
- Performance monitor

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Bragadiru said:
Hi,

From time to time, I get an error message : "... all pooled connections
were
in use and ... " and I want to check how many connections are opened
Click to expand...
Click to expand...
by
my
Click to expand...
Click to expand...
 
Back
Top