A common error that pops up in application logs as a result of long executions is: When these start showing up in an application log, it is a good indicator that a performance issue may be occurring in SQL Server. So far as SQL Server is concerned, it thinks the application dropped or cancelled the […]
Read Moreextended events
Is your system_health session missing data?
It is fairly common knowledge that the system_health session is a useful tool for resolving issues such as deadlocks. I see a lot of posts on other websites where people report a discrepancy in the number of deadlocks monitored by perfmon or tracing vs what shows up in the system health session. This is the result […]
Read More