A friend of mine needed to figure out SQL Server deadlocks a while ago.
I hadn’t been doing stuff like this for quite some time, but remembered that unlike old SQL Server days, it had become relatively easy.
These links show you how:
- [Wayback/Archive] SQL SERVER – How to get historical deadlock Information from System Health Extended Events? – SQL Authority with Pinal Dave which was just slightly below this result from the Google Query at the bottom:
- [Wayback/Archive] How to select deadlock history in last 7 days – Microsoft Q&A
Query:
[Wayback/Archive] sql server find deadlock history – Google Search
--jeroen





