Re: So, how do I monitor *open* connections? by William
William
Tue Jun 28 17:36:04 CDT 2005
Yes, but these don't work when the server closes the connection from its
end. That won't be a feature until ADO.NET 2.0.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Francois Bonin [MVP]" <thecois@gmail.com> wrote in message
news:OkJTr4CfFHA.572@TK2MSFTNGP15.phx.gbl...
> If you are using the .NET framework for your program, you can hook to the
> StateChange events of the SqlConnection objects you are creating to have
> some code of yours called when the connections get opened or closed.
> That way, you will have a live picture of what conenctions are opened.
>
> "Sgt. Sausage" <nobody@nowhere.com> wrote in message
> news:d1c5d$42c0a2e4$42a1e6c9$1106@FUSE.NET...
>>I knew somebody would use that answer. Yes, sp_who, and sp_who2
>> work. Sorry I didn't make myself clear -- I want to monitor in
>> real time and watch stuff happening "live" like with the performance
>> counters.
>>
>>
>> "W.G. Ryan eMVP" <WilliamRyan@NoSpam.gmail.com> wrote in message
>> news:%238Ixxn3eFHA.2420@TK2MSFTNGP10.phx.gbl...
>>> If you're using Sql Server, I believe sp_who returns that information.
>>>
>>> --
>>> W.G. Ryan MVP (Windows Embedded)
>>>
>>> TiBA Solutions
>>> www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
>>> "Sgt. Sausage" <nobody@nowhere.com> wrote in message
>>> news:f13d5$42c09787$42a1e6c9$10492@FUSE.NET...
>>>> I can look at performance monitor for pools, pooled
>>>> connections etc. What I don't see is a way to tell, say,
>>>> of the 25 pooled connections in the pool, how many are
>>>> active and open.
>>>>
>>>> Anyone know of any tools for this?
>>>>
>>>> Any ideas?
>>>>
>>>> Anyone ...
>>>>
>>>>
>>>
>>>
>>
>>
>
>