ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

UIM - Multiple queries related to checkpoint for sql server probe

book

Article ID: 200626

calendar_today

Updated On:

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

Release : 9.0.2 / 20.x

Component : UIM - SQLSERVER : 5.42 x

Resolution


Depends on target SQL server database version being monitored 

If SQL Sever is greater then or equal to 2005 i.e 9.00.xxxx then MSSql90[] or MSSql90NoLock[] will be used from the queries provided for concerned checkpoints in KB below
If SQL Sever 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?
https://knowledge.broadcom.com/external/article?articleId=44005

Also there are two queries for each checkpoint , example 

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

Symptom:
The probe can create a deadlock when querying the sqlserver 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 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

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-troubleshooting.html