Queries used by the sqlserver Probe in UIM

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Queries used by sqlserver probe are provided in this kb article. Running these queries requires sufficient permissions being granted to the user used in sqlserver probe.
This is described in UIM probe document: Access Prerequisites

Environment

• UIM 8.5x. 9.x, 20.x
• Sqlserver 5.4x

Resolution

Download the attachment available at the bottom of this KB.

Additional Information

Supported Versions for sqlserver probe 

Supported versions

https://buildnumbers.wordpress.com/sqlserver/

https://stackoverflow.com/questions/18753886/sql-server-file-names-vs-versions 

From the KB (it also has sql queries for older versions).
If SQL Sever is greater then or equal to 2005 i.e 9.00.xxxx then, MSSql90[] or MSSql90NoLock[] will be used. 
If SQL Sever is equal to 2000 i.e 8.00.xxxx, then MSSql80[] or MSSql80NoLock[] will be used.

fg_freespace_with avial_disk and logfile_usage_with_avail_disk query
The fg_freespace_with avial_disk  in the attached document is used for both fg_freespace_with avial_disk and for the logfile_usage_with_avail_disk query
there is an attached sample query that can be used for troubleshooting.

Added metric data calculation for sql server file. 

 

check_dbalive checkpoint is not a real sql checkpoint. If the probe successfully connects to the database, then it writes a 1 to the QOS, if the probe fails to connect to the database, it writes a 0 and sents an alarm.