Can I killed the sleeping sessions which block the other sessions.
Recently My SQL server (MS SQL7) is getting slow.
I used the "select * from master..sysprocesses where status = 'sleeping' and dbid >=5"
and found there are hundreds sleeping session, and several session block the other session.
So I killed those sleeping session. The server got normal.
But I have been told "this is a total wrong operation, This could corrupt the database or make the system out of balance." Is it right ? why??
Do I need to ask user log off the database, then kill the
session. If the SQL server got very slow, and user can not log off
What can I do?
Can I ask the vender(developer) to revise their code to kill the sleeping session periodly.
Thanks in advance
Kevin
Recently My SQL server (MS SQL7) is getting slow.
I used the "select * from master..sysprocesses where status = 'sleeping' and dbid >=5"
and found there are hundreds sleeping session, and several session block the other session.
So I killed those sleeping session. The server got normal.
But I have been told "this is a total wrong operation, This could corrupt the database or make the system out of balance." Is it right ? why??
Do I need to ask user log off the database, then kill the
session. If the SQL server got very slow, and user can not log off
What can I do?
Can I ask the vender(developer) to revise their code to kill the sleeping session periodly.
Thanks in advance
Kevin