Making sense of MSSQL database size

[MonitorGuy]

We recently setup MSSQL monitoring using the wizard, and Database Size was the one area I couldn't explain to the DBA.

Monitoring returned the database size as 4544.0KB - wish we had option to select MB or GB instead of just KB.

We guessed wrong on the thresholds, and had to bump up to get the alerts to stop: --warning 48,874,368 --critical 53,214,400

Check command: check_xi_mssql_database2
Command view: $USER1$/check_mssql_server.php -H $HOSTADDRESS$ $ARG1$
ARG1: --checktype 'database' -U '$USER10$' -P '$USER11$' --perftype default --mode datasize --warning 48,874,368 --critical 53,214,400

Maybe there's a different check we can try?

Thanks!

[dchurch]

Does it work any better if you remove the commas from the warning and critical thresholds?

Code: Select all

ARG1: --checktype 'database' -U '$USER10$' -P '$USER11$' --perftype default --mode datasize --warning 48874368 --critical 53214400

[MonitorGuy]

Without commas, things are making more sense:

OK: Database size is 4544.0KB|data_file_size=4544.0KB;5000;6000;;

WARNING: Database size is 4544.0KB|data_file_size=4544.0KB;4000;6000;;

CRITICAL: Database size is 4544.0KB|data_file_size=4544.0KB;4000;4500;;

Still not sure KB is the right sizing, but this will work for now...

Thanks for the suggestion!

Craig

[scottwilkerson]

Without commas, things are making more sense:

OK: Database size is 4544.0KB|data_file_size=4544.0KB;5000;6000;;

WARNING: Database size is 4544.0KB|data_file_size=4544.0KB;4000;6000;;

CRITICAL: Database size is 4544.0KB|data_file_size=4544.0KB;4000;4500;;

Still not sure KB is the right sizing, but this will work for now...

Thanks for the suggestion!

Craig

Great!

Locking thread