Viewing 6 posts - 16 through 21 (of 21 total)
john.m.couch (9/17/2012)
Did you look at the script I provided? IT has everything you need to do scripted in it.
Thanks for providing the script.
I have limited access to production env, hence...
September 18, 2012 at 1:21 pm
Jonathan Kehayias (9/17/2012)
hello mahesh (9/17/2012)
May be it got overlapped as the deadlock event occured...
September 17, 2012 at 6:15 pm
Still noluck. I tried searching for key words: 'dead' , 'victim' in xml and not found any.
May be it got overlapped as the deadlock event occured couple of weeks back.
Thanks
September 17, 2012 at 4:11 pm
We had couple of deadlock issues,
but nothing is captured with this query..
select XEventData.XEvent.value('(data/value)[1]', 'varchar(max)') as DeadlockGraph
FROM
(select CAST(target_data as xml) as TargetData
from sys.dm_xe_session_targets st
join sys.dm_xe_sessions s on s.address = st.event_session_address
where name...
September 17, 2012 at 3:11 pm
Jonathan Kehayias (2/20/2009)
Comments posted to this topic are about the item <A HREF="/articles/deadlocks/65658/">Retrieving Deadlock Graphs with SQL Server 2008 Extended Events</A>
Whats the requirement for it to work on 2008 R2...
September 17, 2012 at 1:05 pm
Hi ZL,
Were you able to solve your issue..?
I m facing similar issue - MERGE stmt performing very slow on SQL 2008 R2 env.
The staging table has couple of million...
March 9, 2011 at 12:28 am
Viewing 6 posts - 16 through 21 (of 21 total)