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 ?