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 |
|
nnalam
Starting Member
1 Post |
 Posted - 2004-07-31 : 13:33:49
|
| Hi, I am new to SQLServer and its tools. How can I get the full info when a deadlock happens ? I turned on T1204 & T3605. Still the info is very cryptic. I read that I can get the SQL from SQLProfiler. I could not get the correct Documentation on this. Can anyone suggest on this ?ThanksNaresh |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-01 : 15:04:36
|
| If you want documentation for this, search Books Online for deadlock. It describes it pretty well. Also, the SQL Server 2000 Performance Tuning Technical Reference by Microsoft Press is a great resource. You need to trace deadlock chain with those trace flags turned. If you do this in Profiler, and have the database id, object id, and TextData you should be able to get all the information you need.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
SQLProfiler