10-20-03, 22:02 #1Registered User
- Join Date
- Oct 2003
Unanswered: Locking in Database make all clients hold
We are using SQL2000 with SP3, Windows 2000 Svr Std with SP4
Sometimes, we found all clients had no response. Later, we found that the all clients are waiting response from sql server.
Then in querry analyzer, we use this script:
select * FROM master..sysprocesses where status='sleeping' AND waittype=0x000 AND open_tran > 0
and then we found out one computer is locking and after request that computer logout the program, then, all clients can run again.
However, I have no idea why this case happen and I am still searching what's the meaning the about select statement.
Can anyone help me?
10-20-03, 22:14 #2Registered User
- Join Date
- Jan 2003
- Nottinghamshire, UK
Try Using Enterprise Manager to look at Current Activity
This should show you who's locking at a glance & provides a lot of usefull info
Sounds like your getting Deadlocks
GW"Everything should be made as simple as possible, but not simpler." - Albert Einstein
"Everything should be made as complex as possible, so I look Cleverer." - Application Developer