Configure MSSQL Database size from KB to %

[akumarhe1868]

Hi,

Please suggest how to configure the MSSQL database size from KB to % as we could see in the Database wizards as KB in Nagios XI

We need to set for warning 75% and Critical 85%

Appreciate your help.

Thanks,
Anand

[scottwilkerson]

Hi,

Please suggest how to configure the MSSQL database size from KB to % as we could see in the Database wizards as KB in Nagios XI

We need to set for warning 75% and Critical 85%

Appreciate your help.

Thanks,
Anand

This isn't possible because there isn't an upper limit to calculate a percentage against. MSSQL databases can grow to any size.

[akumarhe1868]

Thank you.

TO find an alternative, we have wrote a script to get the space usage and configured using wizard MSSQL Query.

Query has been Ok status with value 77 but this was not showing an alert if I set warning 75 and critical 80

Could you please advise how this alert issue can be overcome.

Thanks,
Anand

[scottwilkerson]

Can you share this script?