February 6, 2009 at 3:01 pm
Hello and thanks in advance. I have been receiving some deadlocks on a server. I have been getting around 2 or 3 a week. To try and figure out the objects involved in the deadlocks, I enabled trace flags 1204 and 1206. I was looking at the output in the error log today and tried to use the DBCC Page command for the pages it gave me. It returned no results for any of the pages only the "DBCC execution completed. If DBCC printed error messages, contact your system administrator." message.
Am I doing something wrong?
February 6, 2009 at 3:25 pm
pls post the trace flag results
Regards,
[font="Verdana"]Sqlfrenzy[/font]
February 6, 2009 at 3:27 pm
I have figured out what was going on. I did not set trace flag 3604 to display the results of DBCC Page to the current connection. Thanks.
February 7, 2009 at 2:16 am
Since you're using 2005, use traceflag 1222 for deadlock graphs, rather than 1204. It's a lot more detailed.
Tracefag 1206? why is that enabled and what does it do?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 9, 2009 at 6:57 am
Trace flag 1206 is used in conjunction with 1204. It displays all locks held by both deadlock parties. Thanks for the 1222. I have enabled it now.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply