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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-24 : 07:38:07
|
| Sudharsanam writes "Dear Sir, Ques: I am facing a severe problem due to the orphaned session/connection. Scnerio: I am accessing the SQL Server 2000 DB, via a COM component written in Visual Basic 6.0 from an ASP Page. But even after closing the connection and destroying the connection objects and all recordset objects, it leaves the connection opened for along time. If i check for number of connections from sysprocesses, it shows upto 50 connections and the difference between the current and last batch time even > 150. I even tried an the same in .NET, but even then i can able to see an orphaned connection for 5 min with Program_name .NET Data Provider. I will be verymuch thankful to you, if you can help me in solving this problem Thanks in AdvanceNB: I am using MDAC 2.7 and .NET FW 1.0" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-24 : 18:20:08
|
| Use SQL Profiler to determine if you are really disconnecting from SQL Server. SQL Profiler will be able to show you everything that is happening in SQL Server. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-02-24 : 18:46:02
|
| How are you determining taht you have orphaned connections? sp_who2? Perfmon?Depending on your Connection Pooling settings, what you are seeing may be normal.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
SQL Server Orphaned Sessions/connections