UIM - Multiple queries related to checkpoint for sql server probe
Article ID: 200626
Updated On:
Products
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>.
Feedback
