Link to home
Start Free TrialLog in
Avatar of knaren1975
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
Avatar of knaren1975
knaren1975

ASKER

a typo error in the question..

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
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
ASKER CERTIFIED SOLUTION
Avatar of agusacil
agusacil
Flag of Indonesia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial