Hello.

We have several MS SQL DB servers.

Sometimes we have problem with database files growth and we know about only when Warning or Error tell us.

For example, disk free space is 100Gb, warning limit is set to 50Gb, Error limit to 20Gb.

We had situation with db error and SQL server created every 5 minutes one file 2Mb size. After half a day we noticed problem when we were running out of free disk space.

Is there any option to predict such situation and set PRTG to send notifications when it notice such abnormal disk behavior ?

Article Comments

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

Hi Greg,

Please navigate to "Setup | System Administration | Monitoring", to find the setting "Unusual Detection".

To detect unusual behavior PRTG checks the latest measurements against previously measured values. Unusual detection works with two methods:

  • Daily (24h): The average of the day before is compared to previous daily averages of the same weekday
  • Hourly: The average of the previous hour is compared to previous hourly averages of the same weekday and the same hour-of-day

Please also find additional information here (please search for "unusual"): https://www.paessler.com/manuals/prtg/monitoring_settings

Kind regards
Andreas Günther, Technical Support


Jun, 2018 - Permalink