SQL server probe issue

book

Article ID: 208697

calendar_today

Updated On:

Products

DX Infrastructure Management CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) NIMSOFT PROBES

Issue/Introduction

We want to monitor the logfile_usage in sqlserver probe. We searched for a few log files in template logfile_usage but we didn't find them.

Environment

Release : 20.x

Component : UIM - SQLSERVER

Resolution

The probe is looking at the log size as a logical unit, not as separate files.
Here is details about the QOS_SQLSERVER_logfile_usage metric:
The QOS_SQLSERVER_logfile_usage Monitors the amount of free space in the transaction log in percentage. If there is at least one transaction log file with "unlimited" growth in a database, the space in the transaction log is considered 100 percent free. Note: For this checkpoint, wherever the given database is in the recovery or restore mode, no metric values would be reported for a given interval of execution.