This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / SQL SEVER SLEEPING PROCESS 问题？请问如果我没有权限KILL SLEEPING PROCESS， 那些SLEEPING PROCESS 会自己TIMEOUT吗。要不然就只好让DBA 帮忙了。不想每次都让DBA帮忙，所以来请教大家的意见。多谢！
-ttaaoo(tao);
2009-1-29
(#5013605@0)
-
There is a ID: SQL Administrator, it can kill dead process, or, any ID in admin group has the same authority. There is a MAX connection setting in SQL, you must kill/quit those unused processes in order to let other go through.
-nicetomeetyou(_);
2009-1-29
(#5014046@0)
-
sleeping process占用不了多少资源， 有几千个idle connection也没问题，干嘛要kill? 况且你kill了人家， 以后该session的sleeping->runnable->running 的升级就会报错
-walkthrough(无始无终);
2009-1-29
(#5014219@0)