Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ofsouto
Starting Member
22 Posts |
 Posted - 2005-01-26 : 12:43:38
|
| Hi, DearIs there any way or tool to know when a connection is opened and when it is closed or if it continues opened?Thank you very much.ObedeBrazil |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2005-01-26 : 13:18:11
|
| sp_who2 or profiler-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
ofsouto
Starting Member
22 Posts |
Posted - 2005-01-26 : 13:50:59
|
| Hi, ChadThank you for your answer.I know these ways. Is there anothe way?Thank you very much.ObedeBrazil |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-01-26 : 17:18:28
|
| Look at the Connections count in Performance Monitor. I've found that useful for debugging leaked connections.Damian |
|
|
|
|
|
|
Opened SQL Connections