Guide to handle high CPU caused by deadlocks
We were working for a customer who was facing below issues on MS SQL Database server: Initial Approach: Issue Identification: Above things helped very little so we started further investigation of deadlocks and execution plans of high CPU queries. We identified below issues: 5. Winner query acquired key lock on entire non clustered index due … Read more