Hello,
On SolarWinds SQL Sentry - Build 2024.4.5.47246
We have recently started to notice a huge discrepancy with reporting on certain events, specifically recording / reporting deadlocks. In comparison we have Redgate monitoring as well and we will see deadlocks being reported in Redgate and for the exact same server in SQL Sentry we do not see ANY deadlocks being recorded.
We have a total 5 servers being monitored.
Of the 5 servers a few are in Azure (native SQL on a Azure VM), AWS (Native SQL on AWS VM), local data center (Native SQL on VM).
We see deadlocks being reported in other servers as expected, but in a handful of servers we again see either NO deadlocks being reported or only a handful (for example may record 1 or 2 but there really may have been 10 total during a given period).
Looking for any advice where to start looking. We have support ticket open right now but that hasn't gotten anywhere at the moment.
Thanks in advance