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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-03-18 : 13:44:48
|
| A friend of mine has a DB that seems to be accumulating processesEnterprise Manager: Management, Current Activity, ProcessesEach of the accumulating processes has a different query in the properties box, and we are trying to understand what would cause a process not to terminate. The calls to the db are done from ASP - no visibilty to the ASP source code (can you fight with your hands tied?)SamC |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-18 : 13:47:00
|
| Try running SQL Profiler to see if there is ever any attempts to logout. Probably the ASP isn't performing the logout, so you will just keep getting more and more connections until you run out of available memory.Tara |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-03-18 : 13:54:55
|
| I'm familiar with ASP users opening and closing sql connections. Not so sure what you mean by logout??San |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-18 : 13:56:40
|
| Well logging out is the same as closing sql connections, it's just that in SQL Profiler you'll see it through the Security Audit\Audit Logout event class.Tara |
|
|
|
|
|
|
Investigative work on sql processes