Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

deadlock graph no statement information Expand / Collapse
Author
Message
Posted Monday, March 18, 2013 3:03 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 12:22 PM
Points: 293, Visits: 811
In a deadlock graph, hovering over the oval for the victim only shows "Statement:". The other oval shows Statement: followed by the stored procedure that was executed.

Does anyone know why the victim oval isn't displaying the statement information?

Microsoft SQL Server 2008 R2 SP2 Enterprise Edition (64-bit)
Post #1432357
Posted Monday, March 18, 2013 4:07 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 7,080, Visits: 12,571
Sometimes the SQL statement is not captured, or it may be a UI bug. Can you save the file and attach the file to this thread? It's possible the data is in the file but the UI is not showing it properly.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1432377
Posted Monday, March 18, 2013 4:25 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 12:22 PM
Points: 293, Visits: 811
I tried running "Extract Event Data..." from the trace and there's certainly additional information in the resulting xdl file.

I wonder if there's a bug in the UI?
Post #1432387
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse