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 though the table has proper INDEXING and table level hints are placed.

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 though the table has proper INDEXING and table level hints are placed.

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.