• sqlguy80 - Wednesday, February 21, 2018 9:48 AM

    Hi

    I was getting alerts about deadlocks continuously every min on the server, I updated stats and alerts stopped. Again after  two days, got deadlock alerts, updated stats, alerts gone.
    did the trace (1222,-1), sent the deadlock victim details to development team.

    What  is the connection between stats and deadlocks?

    Thanks

    Could you check the cardinality estimator settings of your SQL Server ?