knaren1975
asked on
Resoving deadlocks
Hi
please let me know , how can we resolve deadlock issues. Will it happens automatically or do we need to do anything to overcome this issue?
Thx
Naren
please let me know , how can we resolve deadlock issues. Will it happens automatically or do we need to do anything to overcome this issue?
Thx
Naren
deadlocks are usually when a user (via query) or a process is accessing a certain table....
Here's an article on how to detect the deadlocks and how to end them if necessary:
http://msdn.microsoft.com/en-us/library/aa213030(v=sql.80).aspx
http://support.microsoft.com/kb/832524
there's even a software if you like a nice gui front end:
http://www.sqlsolutions.com/products/sql-deadlock-detector/index.html
Here's an article on how to detect the deadlocks and how to end them if necessary:
http://msdn.microsoft.com/en-us/library/aa213030(v=sql.80).aspx
http://support.microsoft.com/kb/832524
there's even a software if you like a nice gui front end:
http://www.sqlsolutions.com/products/sql-deadlock-detector/index.html
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi
please let me know , how can we resolve deadlock issues. Will it resolve automatically or do we need to do anything to overcome this issue?
Thx
Naren