I have a UPDATE and INSERT query in table which is getting executed multiple times to update record(once every 5 seconds). This Procedure is used in multiple procedures so the execution count is high, and i am getting deadlock issues on the UPSERT procedure even tho the table has proper INDEXING and Table level hints are placed.
I have tried every possible scenario and went through all the BLOGS and comments yet no luck in reducing the deadlock.
New contributor
HITESH KARSHINKAR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.