Hi, Iam new to sql server.I have to find where deadlocks will occur in storedprocedures. Pls tell me how to find deadlocks in sql server 2005 express & how to resolve those.
Enable the trace flag 1204 and check in error log.
Senthil Kumar C ------------------------------------------------------ MCITP - Database Administration SQL SERVER 2008 MCTS - Database Development SQL SERVER 2008
Don't use traceflag 1204, that's an old one from SQL 2000 days and has limited information.
Switch traceflag 1222 on. That will result in a detailed deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
How to find deadlocks in sql server 2005 express
Posted - 01/19/2012 : 02:21:34
