Training: Reporting in SQL Monitor. Watch now.
How do I fix Dashboard performance issue after a night long of deadlock alerts?
We had a deadlock occur last night and SQL Server did not resolve it. I had to manually kill a select process for a batch of INSERTs to progress. There were 392K deadlock alerts stacked and waiting in SQL Monitor that morning. Now, the Dashboard has poor performance, taking much longer to load browser pages. Our data purge settings on the SQL Monitor will clear alerts after 3 months - can you suggest a specific action I can take to get rid of the 392K deadlock graphs/alerts (short of purging alert history)?
0 · Share on Twitter