Search found 12 matches

by dbasupport
Thu Nov 19, 2020 6:22 am
Forum: Nagios XI
Topic: CRITICAL - cannot connect to information_schema. Unknown
Replies: 1
Views: 625

CRITICAL - cannot connect to information_schema. Unknown

Hi Team , I unable to configure the monitors on the Maria DB through Nagios ,getting below error . I am able to login with user mysql_monitor and its password locally on the server but through Nagios application throwing below error [nagios@manxi01.marketingassociates.com ~]$ /usr/local/nagios/libex...
by dbasupport
Mon Jul 27, 2020 10:09 am
Forum: Nagios XI
Topic: Page life expectancy critiacl alert
Replies: 4
Views: 1686

Re: Page life expectancy critiacl alert

Sorry--- typo error ,its check_nt is the plugin
by dbasupport
Mon Jul 27, 2020 2:27 am
Forum: Nagios XI
Topic: How to configure the cluster hard drive
Replies: 1
Views: 182

How to configure the cluster hard drive

Hi We are configuring the windows and sql server database performance counter using nsclient++ and with check_nt plugin . I have sql server database hosted in cluster , here we have two nodes for the cluster and database data is placed in cluster hard drive . I would to know how to configure the clu...
by dbasupport
Mon Jul 06, 2020 11:38 am
Forum: Nagios XI
Topic: Page life expectancy critiacl alert
Replies: 4
Views: 1686

Re: Page life expectancy critiacl alert

This is the present setting which is set for PLE .

-l "\\SQLServer:Buffer Manager\\Page life expectancy","MSSQL Buffer Mgr Page life expectancy","sec" -w 86400 -c 172800!!!!!
by dbasupport
Mon Jul 06, 2020 11:37 am
Forum: Nagios XI
Topic: Page life expectancy critiacl alert
Replies: 4
Views: 1686

Page life expectancy critiacl alert

Hi , We are using the check_t plugin to monitor the page life expectancy performance counter for sql server database . Getting critical alert , need some inputs to resolve this alert . We have 4Gb physical memory for the server . From the below value 2811460.00 sec , I belive this the cumulative val...
by dbasupport
Wed Jun 03, 2020 11:48 pm
Forum: Nagios XI
Topic: Critical performance counter for sql servers through Nagio
Replies: 5
Views: 3668

Re: Critical performance counter for sql servers through N

Hi Benjaminsmith ,

Thanku so much for the information and update , even I had research and considered the same performance counter which you have mentioned .

Thanks
by dbasupport
Wed Jun 03, 2020 2:28 am
Forum: Nagios XI
Topic: Critical performance counter for sql servers through Nagio
Replies: 5
Views: 3668

Re: Critical performance counter for sql servers through N

Hi benjaminsmith, Thanks for information updated , basically we would be monitoring the sql server database through Nagios XI . We have two plugin as default for monitoring the sql server database through sql server wizard from Nagios . These are two plugin ./check_mssql_database.py and check_mssql_...
by dbasupport
Mon Jun 01, 2020 6:43 am
Forum: Nagios XI
Topic: Critical performance counter for sql servers through Nagio
Replies: 5
Views: 3668

Critical performance counter for sql servers through Nagio

Hi Team , We would to monitor the sql server and sql server database through Nagios XI . 1. I would like to know which most critical performance counter from sql server database point of view . 2. In Nagios , we have two wizard related to MSQL database , is that sufficient ? 3. There is any other pl...
by dbasupport
Fri May 22, 2020 1:18 pm
Forum: Open Source Nagios Projects
Topic: 8456, "Login failed for user ' nagios'.DB-Lib error message
Replies: 2
Views: 5608

8456, "Login failed for user ' nagios'.DB-Lib error message

Hi , Any idea on the error Unknown (18456, "Login failed for user ' nagios'.DB-Lib error message 20018, severity 14:\ General SQL Server error: Check messages from the SQL Server\\ DB-Lib error message 20002, severity 9:\\ Adaptive Server connection failed (MAMSSQLSNDBOX01.client.ma:1433)\\ &qu...
by dbasupport
Thu May 21, 2020 12:05 am
Forum: Nagios XI
Topic: Monitors to monitor the sql server database through Nagios
Replies: 3
Views: 390

Re: Monitors to monitor the sql server database through Nag

Can I have the default value ,attached excel document has the default threshold which I got from configuration wizard .

Please let me know if these default values are good to configure in the Nagios , any recommended values .

Thanks