Page 1 of 1
Oracle and SQL Monitoring
Posted: Thu Mar 01, 2018 8:59 pm
by 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
Re: Oracle and SQL Monitoring
Posted: Fri Mar 02, 2018 11:39 am
by bolson
Re: Oracle and SQL Monitoring
Posted: Mon Mar 19, 2018 11:15 am
by 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
Re: Oracle and SQL Monitoring
Posted: Mon Mar 19, 2018 3:42 pm
by 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