Post reply

Deadlock Analysis from SQL trace file.

  • September 10, 2014 at 3:51 am

    #296082

    HI,

    I am getting deadlock in my production, i was taken deadlock information from trace file , i found deadlock graph but i am unable to find exact scenario . I am attaching deadlock trace file, can you please explain how can identify where is the issue.

    Thanks in advance.

  • September 10, 2014 at 4:15 am

    #1744367

    I cant open your trace file.

    Can you post the text where you would be seeing something like "graph generated"

    ----------
    Ashish

  • September 10, 2014 at 4:22 am

    #1744368

    crazy4sql (9/10/2014)

    I cant open your trace file.

    Can you post the text where you would be seeing something like "graph generated"

    it is .trc file, so it will open in sql management studio, can you try to open sql management studio.

    Can u search with this keyword "Deadlock graph" in eventclass column

  • September 10, 2014 at 4:27 am

    #1744370

    PRAMANA.DBA (9/10/2014)

    HI,

    I am getting deadlock in my production, i was taken deadlock information from trace file , i found deadlock graph but i am unable to find exact scenario . I am attaching deadlock trace file, can you please explain how can identify where is the issue.

    Thanks in advance.

    Please ignore, I opened it in sql 2k12 and its opening. Checking it

    ----------
    Ashish

  • September 10, 2014 at 4:33 am

    #1744375

    crazy4sql (9/10/2014)

    PRAMANA.DBA (9/10/2014)

    HI,

    I am getting deadlock in my production, i was taken deadlock information from trace file , i found deadlock graph but i am unable to find exact scenario . I am attaching deadlock trace file, can you please explain how can identify where is the issue.

    Thanks in advance.

    Please ignore, I opened it in sql 2k12 and its opening. Checking it

    OK, you getting deadlock because of two conflict update statement.

    See line 11040 in your trace file

    ----------
    Ashish

  • September 10, 2014 at 5:17 am

    #1744387

    crazy4sql (9/10/2014)

    crazy4sql (9/10/2014)

    PRAMANA.DBA (9/10/2014)

    HI,

    I am getting deadlock in my production, i was taken deadlock information from trace file , i found deadlock graph but i am unable to find exact scenario . I am attaching deadlock trace file, can you please explain how can identify where is the issue.

    Thanks in advance.

    Please ignore, I opened it in sql 2k12 and its opening. Checking it

    OK, you getting deadlock because of two conflict update statement.

    See line 11040 in your trace file

    Thanks ...

    i have identified graph but there is only one update statement , that is very big graph , based on that graph how i can identify which statement and which statement blocking.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply