some devices in the probe sqlserver are not reporting the real space allocated

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Identified that the probe SQLserver is not reporting the real free space available / allocated. 

 

Environment

Release : 20.3

Component : UIM - SQLSERVER

Resolution

This is working as designed.

If the database is set to allow unhindered growth, it will show 100% free for this checkpoint.
For the reality,  should be used the database_size checkpoint.

QOS_SQLSERVER_free_space

PercentMonitors the amount of free space in data files in percentage.

Note: If there is at least one file with "unlimited" growth, the space in the whole database is considered as 100% free. Using file groups, could be misleading; therefore, must deactivate this checkpoint and use only the "fg_free_space" checkpoint.