SQL Deadlock Errors

book

Article ID: 33934

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

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.


Environment

Release:
Component: UIMSQR