Multiple queries related to checkpoint for sql server probe

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Can see multiple queries for each checkpoint for queries used by sqlserver probe .

On what factors do these multiple queries depend?

Environment

DX UIM 20.4.x / 23.4.x

SQLSERVER : 5.42 or higher 

Resolution

Depends on the target SQL server database version being monitored 

If SQL Sever is greater than or equal to 2005 i.e 9.00.xxxx then MSSql90[] or MSSql90NoLock[] will be used from the queries provided for the concerned checkpoints in KB below
If SQL Server is equal to 2000 i.e 8.00.xxxx, then MSSql80[] or MSSql80NoLock[] will be used

KB: What Queries (updated ) are used by the sqlserver Probe in UIM?

Also, there are two queries for each checkpoint, for example 

The MSSql90NoLock query will be used when the no_lock key is configured for the connection else normal MSSql90 will be used. 
 
Use of no_lock can be configured as below. Default is a query with lock

Symptom:
The probe can create a deadlock when querying the SQL server database, and impact the business transactions.

Solution:
Follow these steps:

Open the probe Raw Configure interface.

Navigate to your connections > <connection name> folder.

Add the no_lock key with a value set to 1.

(Optional) Repeat the above steps for each connection, as required.

The probe does not lock the database when querying the database using your <connection name>.

 

Additional Information

sqlserver Troubleshooting