SQL Server 2008 Extended Events 3
Now lets create a New Event Session to capture Deadlock Victims
IF EXISTS(SELECT * FROM sys.server_event_sessions WHERE name='Demo_session_Deadlock')
DROP EVENT SESSION Demo_session_Deadlock ON SERVER
GO
-- CREATES THE SESSION
CREATE EVENT SESSION Demo_session_Deadlock
ON SERVER
ADD EVENT
sqlserver.lock_deadlock
( ACTION ( sqlserver.database_id,
sqlserver.client_app_name,
sqlserver.sql_text ) )
ADD TARGET package0.asynchronous_file_target
-- CONFIGURES THE FILE TARGET
(set filename = 'G:Datadata2.xel' , metadatafile = 'G:Datadata2.xem')
GO
-- STARTS THE SESSION
ALTER EVENT SESSION Demo_session_Deadlock ON SERVER STATE = START
GO
Now create a deadlock by using some updates
--DeadLock Simulation
--First Session
begin tran
update [Demo1] set [Column1] = 'abcd'
/*
--Second Session, Run this from Another window
begin tran
update [Demo2] set [column1] = 'abcd'
update [Demo1] … Read the rest