Oracle and SQL Monitoring

[muadba]

We would need to monitor the below parameters in MSSQL and Oracle .Can we get help to find the plugin /script to setup the monitoring .

Database availability/state changes/Listener status (Up/Down)
Database File growth - DB File, Log File and Temp File for all databases (users and system)
Backup monitor
Blocks/Locks in database
Security audit
Maintenance jobs
Critical errors/alerts in event viewer

[bolson]

For Oracle:

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

And for MSSQL:

https://exchange.nagios.org/directory/A ... rd/details

[gregwhite]

I just want to confirm that this MSSQL monitoring wizard will monitor database instances on a single server for availability. We are do a database consolidation project and they are looking for us to be able to monitor multiple instances on a single server.

Thanks,
Greg

[kyang]

According to the MSSQL documentation,

Do both instances have different ports on the same server?

You would have to reference different instance names and create two checks as I don't think the plugin accepts multiple instances in 1 check.

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

Code: Select all

[root@centos7x64 libexec]# ./check_mssql_server.py --help
Usage: check_mssql_server.py -H hostname -U user -P password -T table --mode

Options:
  -h, --help            show this help message and exit

  Required Options:
    -H HOSTNAME, --hostname=HOSTNAME
                        Specify MSSQL Server Address
    -U USER, --user=USER
                        Specify MSSQL User Name
    -P PASSWORD, --password=PASSWORD
                        Specify MSSQL Password

  Optional Connection Information:
    -I INSTANCE, --instance=INSTANCE
                        Specify instance
    -p PORT, --port=PORT
                        Specify port.

  Nagios Plugin Information:
    -w WARNING, --warning=WARNING
                        Specify warning range.
    -c CRITICAL, --critical=CRITICAL
                        Specify critical range.

  Mode Options:
    --pagelooks         Page Lookups Per Second
    --batchreq          Batch Requests / Sec
    --connections       Number of open connections
    --lockwaits         Lockwaits / Sec
    --pagereads         Page Reads / Sec
    --totalpages        Total Pages (Cumulative)
    --readahead         Readahead Pages / Sec
    --pagewrites        Page Writes / Sec
    --stolenpages       Stolen Pages
    --targetpages       Target Pages
    --fullscans         Full Scans / Sec
    --locktimeouts      Lock Timeouts / Sec
    --memory            Used server memory
    --test              Run tests of all queries against the database.
    --freepages         Free Pages (Cumulative)
    --bufferhitratio    Buffer Cache Hit Ratio
    --averagewait       Average Wait Time (ms)
    --time2connect      Time to connect to the database.
    --checkpoints       Checkpoint Pages / Sec
    --lockrequests      Lock Requests / Sec
    --pagelife          Page Life Expectancy
    --databasepages     Database Pages
    --deadlocks         Deadlocks / Sec
    --cachehit          Cache Hit Ratio
    --pagesplits        Page Splits / Sec
    --lockwait          Lock Wait Time (ms)
    --lazywrites        Lazy Writes / Sec
    --sqlcompilations   SQL Compilations / Sec
    --cpu               Server CPU utilization