Queries used by the sqlserver Probe in UIM

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (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 20.x, 23.4+
• Sqlserver 5.x+

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 

fg_freespace_with avail_disk and logfile_usage_with_avail_disk query

• The fg_freespace_with avail_disk  in the attached document is used for both fg_freespace_with avail_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 sends an alarm.