?
Solved

deadlock trace output

Posted on 2012-08-23
3
Medium Priority
?
825 Views
Last Modified: 2012-09-18
I have deadlock occurs in MS SQL 2008.

I look at the following instruction

http://www.mssqltips.com/sqlservertutorial/252/tracing-a-sql-server-deadlock/

and turn on trace by issuing command

DBCC TRACEON (1204, -1)
DBCC TRACEON (1222, -1)

Where to see the Trace Flag 1222 Output and Trace Flag 1204 Output.

I open the MS SQL log, i don't any deadlock info.

I want to see the output like the link above listed. Where to get that. Can you tell me the steps to see it
0
Comment
Question by:wasabi3689
3 Comments
 
LVL 9

Accepted Solution

by:
Vijaya Reddy Pinnapa Reddy earned 800 total points
ID: 38328141
0
 

Author Comment

by:wasabi3689
ID: 38335099
Hi,

I make it clear, I want to re-explain the question
I think my problem is I don't know why

1. I issue command for tracing deadlock


DBCC TRACEON (1204, -1)
DBCC TRACEON (1222, -1)

and place the SQL profiling.

I can capture deadlock info from SQL profiling but, when I go to SQL Server Log, I don't see any deadlock info except the lines about I issue the DBCC comand, nothing more than that. I don' understand why

How do I know the SQL server log is working to capture info? Anyone know why the deadlock info was not captured by the log?
0
 
LVL 9

Assisted Solution

by:keyu
keyu earned 800 total points
ID: 38335550
the best way to verify it and check it is using sql profiler..its free component coming with sql server

for more info on sql profiler you can refer below link..

http://www.simple-talk.com/sql/learn-sql-server/how-to-track-down-deadlocks-using-sql-server-2005-profiler/

http://www.sqlsolutions.com/products/sql-deadlock-detector/

http://msdn.microsoft.com/en-us/library/ms188246.aspx

to view it inside sql log you need to set trace on..

To identify a deadlock, you must first obtain log information. If you suspect a deadlock, you must gather information about the (SPIDs) and the resources that are involved in the deadlock. To do this, add the -T1204 and the -T3605 startup parameters to SQL Server. To add these two startup parameters, follow these steps:

• Start SQL Server Enterprise Manager.
•Select, and then right-click the server.
•Click Properties.
•Click Startup Parameters.
•In the Startup Parameters dialog box, type -T1204 in the Parameters text box, and then click Add.
•In the Parameters text box, type -T3605, and then click Add.
•Click OK.

refer below link for the same..

http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/b9984ce7-5158-4b11-8aeb-3bb19f582818/
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question