Skip to content

Instantly share code, notes, and snippets.

@spaghettidba
Created October 19, 2017 10:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save spaghettidba/425552250b3287b8c2073964712c73d7 to your computer and use it in GitHub Desktop.
Save spaghettidba/425552250b3287b8c2073964712c73d7 to your computer and use it in GitHub Desktop.
deadlocks.json
{
"Target": {
"ServerName": "(local)\\SQL2014",
"SessionName": "deadlocks",
"FailOnProcessingError": false,
"Responses": [
{
"__type": "EmailResponse",
"SMTPServer": "localhost",
"Sender": "from@test.com",
"To": "dba@localhost.localdomain",
"Subject": "Deadlock occurred",
"Body": "Deadlock occurred at {collection_time}",
"Attachment": "xml_report",
"AttachmentFileName": "deadlock.xdl",
"HTMLFormat": true,
"Events": [
"xml_deadlock_report"
]
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment