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 |
|
JeffS23
Posting Yak Master
212 Posts |
 Posted - 2007-12-31 : 15:25:15
|
| I am wondering if there is a software program or something that is part of sql server 2000 that will show if I have any open connections in my classic asp code. Does anyone know of any? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-31 : 15:34:33
|
| Just run sp_who/sp_who2 in Query Analyzer.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
JeffS23
Posting Yak Master
212 Posts |
Posted - 2007-12-31 : 15:54:15
|
| I have used this before, but would I assume a lot of sleeping connections means I have some pages that aren't closed properly? I don't see that when I look at it, but curious if that would be a good sign to look for. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-31 : 16:16:19
|
| You can use SQL Profiler to see what the connections are actively doing.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-31 : 23:51:16
|
| You'll see them if app connects to sql with connection pooling. |
|
|
|
|
|
|
Find open connections sql server 2000