Linked Questions

-1
votes
1answer
54 views

Queries involved in deadlock [duplicate]

Is it possible to send queries involved in a deadlock via db mail alert in SQL Server 2005 on mail? If it is possible, then what is the best way to do this?
0
votes
0answers
20 views

Finding rows affected by deadlock on page locks [duplicate]

We've got a db that has been pretty much deadlock free for over 6 months, but a day or two ago we had over 60, all on the same two or three pages of the same table (~12,000,000 rows, ~250 bytes per ...
5
votes
1answer
7k views

How to convert an XML deadlock file into a graph or something readable?

I'm looking for a easy or manageable way to read an XML file, specifically the XML output for SQL Server deadlocks. I have some servers that are not being monitored for various reasons. I found the ...
4
votes
1answer
2k views

Read system_health event_file instead of ring_buffer for deadlocks extended events

I'm currently using this disaster to locate recent deadlocks by reading the system_health Extended Events ring buffer. select top 2000000000 XEvent.value('@timestamp', 'datetime2(3)') as ...
2
votes
3answers
822 views

Transaction deadlock during restore

I am working on PS script to restore database backups and I have following SQL script that I am running from PS Invoke-SQLcmd command: USE master GO ALTER DATABASE mydatabase SET SINGLE_USER WITH ...
2
votes
1answer
612 views

Getting parsable deadlock XML from SQL Server error log

I need to be able to grab deadlocks from the SQL Server log file (for various reasons, cannot use Extended events (and that includes the default system health extended event) or WMI) I have enabled ...
2
votes
0answers
663 views

Extended Events not displaying today's deadlock information

I am using the following query to retrieve deadlock xml. select create_time,XEventData.XEvent.value('(data/value)[1]', 'varchar(max)') as DeadlockGraph FROM (select s.create_time,CAST(target_data as ...
1
vote
1answer
239 views

It is mandatory to create a route when creating an event notification?

I'm starting with service broker. Already managed to setup an event notification for blocked processes based on this answer and it's working flawlessly. Then I wanted to setup another one to notify ...
2
votes
1answer
65 views

Audit full text activity

I need to find when and which user created full text catalog, and who added/modified/deleted the columns (that were full text indexed) in that full text catalog.
0
votes
1answer
43 views

Do trace flags 1204 and 1222 give any more information than available via the xml_deadlock_report event in Extended Events?

I am exploring deadlock detection approaches. Trace flags 1204 and 1222 Extended events (xml_deadlock_report) Do the trace flags contain any more data than what is available via the Extended Events ...