Marcelo Fonseca

Querying deadlock graph from SQL Extended Events

Sample script to read deadlock graph XML from default system health XEvent.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(10)

You rated this post out of 5. Change rating

2016-09-16 (first published: 2014-10-16)

4,680 reads

Reading tutorials is fine. Shipping something is better. If you are trying to break...

We work hard at Redgate, though with a good work-life balance. One interesting observation...

Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...

Comments posted to this topic are about the item Liability for AI Errors

Hello , I would like to run a stored procedure on a secondary replica...

Comments posted to this topic are about the item Pro SQL Server Internals

I run this command to start SQLCMD:

sqlcmd -S localhost -E -c "proceed"

At the prompt, I type this (the 1> and 2> are prompts):

1> select @@version
2> go

What happens?