deadlock trace output

Posted on 2012-08-23
Last Modified: 2012-09-18
I have deadlock occurs in MS SQL 2008.

I look at the following instruction

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
Question by:wasabi3689
    LVL 9

    Accepted Solution


    Author Comment


    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?
    LVL 9

    Assisted Solution

    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..

    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..

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    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.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now