Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
balaram19
Starting Member
9 Posts |
 Posted - 2012-01-19 : 02:21:34
|
| 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. balaram,7702459089ivbalaram |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2012-01-19 : 02:32:55
|
| Enable the trace flag 1204 and check in error log.Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008 |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-19 : 03:21:50
|
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.DBCC TRACEON(1222,-1) --Gail ShawSQL Server MVP |
|
|
|
balaram19
Starting Member
9 Posts |
Posted - 2012-01-20 : 02:37:19
|
| Thanx to you both ivbalaram |
|
|
|
|
|
|
How to find deadlocks in sql server 2005 express