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 - 2005-02-16 : 08:18:22
|
| Phani Kumar Gotety writes "Hi,We have several SQL Servers ( both 7.0 and 2000) which we monitor.There are couple of servers which are bogged down by orphaned processes. Some times it goes to such an extent that those servers need to be rebooted.I have the basic idea about the orphaned processes but to my idea, the best way is to track down the actual computers which are causing them and tune the applications or hardware accordingly ( correct me if I am wrong).My request here is what would be the best way to to deal with this problem. I am sorry if my question is vague and my apolozies for not furnishing the service packs details here as I donot have them on hand right now.Any help would be greatly appreciated.ThanksPhani" |
|
|
|
|
|
The best way to deal with orphaned processes