SQL Deadlock Errors

Document ID : KB000033934
Last Modified Date : 14/02/2018
Show Technical Document Details
sql_response probe was generating the following alarm
Profile <PROFILE NAME>, Execute SQL,COM error [0x80004005] Unspecified error - [Microsoft OLE DB Provider for SQL Server] Transaction (Process ID <PROCESS ID>) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Upon researching the query it was discovered that it was running every two minutes against the customer's Nimsoft database.

The alarms were only being generated during the data_engine's maintenance window.

We increased the run interval for the profile and implemented a NOLOCK hint on the query defined in that profile.
Example:

SELECT <COLUMN>?
FROM <TABLE> WITH (NOLOCK)

No alarms were generated after making these modifications.