Page 1 of 1
Configure MSSQL Database size from KB to %
Posted: Thu Sep 20, 2018 7:44 am
by 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
Re: Configure MSSQL Database size from KB to %
Posted: Thu Sep 20, 2018 1:08 pm
by scottwilkerson
akumarhe1868 wrote: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.
Re: Configure MSSQL Database size from KB to %
Posted: Fri Sep 21, 2018 3:57 am
by 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
Re: Configure MSSQL Database size from KB to %
Posted: Fri Sep 21, 2018 7:09 am
by scottwilkerson
Can you share this script?