Drive Threshold

[zormar00]

Hi
Is it by any chance possible to combine Percent % and GB when monitoring for disk space. This is a common issue for large disks and monitoring tools.
Percentage free space of a large disk requires a lot of free space which in my opinion is not always necessary.
Currently I am monitoring disk space using Powershell including a combination of Percent and Free GB:

Where-Object {$.PercentFree -lt 20 -and $.Free/1gb -lt 100}

This would be a nice feature in DBA Dash.

[DavidWiseman]

Thanks for the suggestion. As a workaround you can adjust the thresholds to use GB at the drive level for larger drives. If you want to do this via script, you could use this to automate it:

INSERT INTO dbo.DriveThresholds(InstanceID,DriveID,DriveWarningThreshold,DriveCriticalThreshold,DriveCheckType)
SELECT InstanceID,DriveID,100,50,'G' 
FROM dbo.Drives D
WHERE Capacity / POWER(1024,3) > 500
AND IsActive=1
AND NOT EXISTS(	SELECT 1 
				FROM dbo.DriveThresholds DT 
				WHERE DT.DriveID = D.DriveID
				AND DT.InstanceID = D.InstanceID
				)

This will add a threshold of 100 (Warning) and 50 (Critical) for any drives larger than 500GB.

[zormar00]

Amazing... thank you for this tool. I am pretty impressed by your work. Keep up the good work.