Nagios Support Forum

Support for Nagios products and services
https://support.nagios.com/forum/

No MSSQL_Lock_Reqests_Per_Sec Performance Graph Data

https://support.nagios.com/forum/viewtopic.php?t=32428

Page 1 of 3

No MSSQL_Lock_Reqests_Per_Sec Performance Graph Data

Posted: Thu Apr 16, 2015 2:06 pm
by hillhealthcenter
No MSSQL_Lock_Reqests_Per_Sec Performance Graph Data is being displayed after December 2014.

Re: No MSSQL_Lock_Reqests_Per_Sec Performance Graph Data

Posted: Thu Apr 16, 2015 2:40 pm
by abrist
I think the uom may have changed in the plugin (in an update) as it was incorrect prior to Dec. What does the check's performance data look like currently?

Re: No MSSQL_Lock_Reqests_Per_Sec Performance Graph Data

Posted: Thu Apr 16, 2015 2:54 pm
by hillhealthcenter
Please see the attached.

Re: No MSSQL_Lock_Reqests_Per_Sec Performance Graph Data

Posted: Thu Apr 16, 2015 3:02 pm
by abrist
Those negative values are very odd. I wonder if there was an overrun. Do you have any errors in the perfdata logs?

Code: Select all

grep centcshdb /usr/local/nagios/var/perfdata.log
grep centcshdb /usr/local/nagios/var/npcd.log

Re: No MSSQL_Lock_Reqests_Per_Sec Performance Graph Data

Posted: Thu Apr 16, 2015 3:26 pm
by hillhealthcenter

Code: Select all

login as: root
[email protected]'s password:
Last login: Thu Apr 16 16:17:51 2015 from 192.168.102.150
[root@nagiosxi ~]# grep centcshdb /usr/local/nagios/var/perfdata.log
2012-07-27 18:03:04 [11045] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_E__Disk_Usage"
2012-10-03 08:47:10 [13819] [0] *** Timeout while processing Host: "centcshdbtest" Service: "_HOST_"
2012-10-27 04:42:36 [18202] [0] *** Timeout while processing Host: "centcshdb" Service: "_HOST_"
2012-10-27 07:45:31 [5699] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_C__Disk_Usage"
2012-11-20 09:36:58 [14495] [0] *** Timeout while processing Host: "centcshdbtest" Service: "Memory_Usage"
2012-11-30 13:22:27 [14186] [0] *** Timeout while processing Host: "centcshdb" Service: "_HOST_"
2012-12-05 11:00:23 [10857] [0] *** Timeout while processing Host: "centcshdb" Service: "Ping"
2012-12-06 17:22:26 [28129] [0] *** Timeout while processing Host: "centcshdbtest" Service: "Ping"
2012-12-07 11:11:31 [2851] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_D__Disk_Usage"
2012-12-09 15:34:54 [14122] [0] *** Timeout while processing Host: "centcshdb" Service: "Ping"
2012-12-17 21:58:23 [5567] [0] *** Timeout while processing Host: "centcshdbtest" Service: "_HOST_"
2013-01-09 09:53:04 [28866] [0] *** Timeout while processing Host: "centcshdb" Service: "Ping"
2013-02-05 00:04:18 [28672] [0] *** Timeout while processing Host: "centcshdb" Service: "_HOST_"
2013-03-12 20:19:16 [18300] [0] *** Timeout while processing Host: "centcshdb" Service: "_HOST_"
2013-03-26 06:57:11 [2262] [0] *** Timeout while processing Host: "centcshdbtest" Service: "_HOST_"
2013-03-29 00:14:12 [20327] [0] *** Timeout while processing Host: "centcshdbtest" Service: "_HOST_"
2013-04-22 00:05:09 [25940] [0] *** Timeout while processing Host: "centcshdbtest" Service: "Ping"
2013-04-25 15:33:39 [9167] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_C__Disk_Usage"
2013-05-08 15:03:57 [7877] [0] *** Timeout while processing Host: "centcshdbtest" Service: "_HOST_"
2013-05-13 12:37:51 [2363] [0] *** Timeout while processing Host: "centcshdbtest" Service: "_HOST_"
2013-05-13 13:52:52 [15247] [0] *** Timeout while processing Host: "centcshdb" Service: "Ping"
2013-05-15 00:52:53 [24368] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_E__Disk_Usage"
2013-05-16 11:37:30 [4868] [0] *** Timeout while processing Host: "centcshdb" Service: "Ping"
2013-05-22 19:42:23 [5414] [0] *** Timeout while processing Host: "centcshdb" Service: "Memory_Usage"
2013-05-25 19:02:47 [8295] [0] *** Timeout while processing Host: "centcshdbtest" Service: "CPU_Usage"
2013-05-30 23:22:54 [397] [0] *** Timeout while processing Host: "centcshdb" Service: "_HOST_"
2013-05-31 06:12:54 [13139] [0] *** Timeout while processing Host: "centcshdbtest" Service: "CPU_Usage"
2013-05-31 20:52:56 [24433] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_E__Disk_Usage"
2013-05-31 20:52:56 [24437] [0] *** Timeout while processing Host: "centcshdbtest" Service: "CPU_Usage"
2013-06-01 10:12:53 [660] [0] *** Timeout while processing Host: "centcshdb" Service: "Memory_Usage"
2013-06-01 17:50:50 [12677] [0] *** Timeout while processing Host: "centcshdbtest" Service: "Ping"
2013-06-01 18:20:50 [4906] [0] *** Timeout while processing Host: "centcshdbtest" Service: "Drive_C__Disk_Usage"
2013-06-03 05:02:38 [3687] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_E__Disk_Usage"
2013-06-03 18:02:48 [32471] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_E__Disk_Usage"
2013-06-03 20:32:50 [27521] [0] *** Timeout while processing Host: "centcshdb" Service: "CPU_Usage"
2013-06-04 16:47:52 [12923] [0] *** Timeout while processing Host: "centcshdbtest" Service: "CPU_Usage"
2013-06-06 01:35:48 [9964] [0] *** Timeout while processing Host: "centcshdb" Service: "CPU_Usage"
2013-06-07 04:20:49 [26881] [0] *** Timeout while processing Host: "centcshdbtest" Service: "Ping"
2013-06-07 09:27:45 [12572] [0] *** Timeout while processing Host: "centcshdb" Service: "_HOST_"
2013-06-07 17:52:47 [27309] [0] *** Timeout while processing Host: "centcshdbtest" Service: "_HOST_"
2013-06-08 01:07:50 [21260] [0] *** Timeout while processing Host: "centcshdb" Service: "_HOST_"
2013-06-08 07:52:46 [20234] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_E__Disk_Usage"
2013-06-10 12:57:40 [18158] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_E__Disk_Usage"
2013-06-12 11:12:37 [6155] [0] *** Timeout while processing Host: "centcshdb" Service: "Memory_Usage"
2013-06-16 11:23:20 [17433] [0] *** Timeout while processing Host: "centcshdbtest" Service: "_HOST_"
2013-06-16 13:13:16 [13569] [0] *** Timeout while processing Host: "centcshdb" Service: "Ping"
2013-06-16 13:53:16 [14827] [0] *** Timeout while processing Host: "centcshdbtest" Service: "CPU_Usage"
2013-06-19 02:18:03 [25121] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_E__Disk_Usage"
2013-06-30 19:03:04 [20737] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_E__Disk_Usage"
2013-07-10 12:47:47 [25214] [0] *** Timeout while processing Host: "centcshdbtest" Service: "Memory_Usage"
2013-07-12 06:03:08 [24738] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_D__Disk_Usage"
2013-07-23 15:47:22 [6858] [0] *** Timeout while processing Host: "centcshdbtest" Service: "_HOST_"
2013-07-24 00:33:21 [31509] [0] *** Timeout while processing Host: "centcshdbtest" Service: "Drive_C__Disk_Usage"
2013-07-30 17:33:17 [11691] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_C__Disk_Usage"
2013-09-25 09:44:49 [27917] [0] *** Timeout while processing Host: "centcshdb" Service: "Drive_D__Disk_Usage"
2013-09-25 09:44:49 [27912] [0] *** Timeout while processing Host: "centcshdbtest" Service: "_HOST_"
2013-10-06 17:12:22 [702] [0] *** Timeout while processing Host: "centcshdbtest" Service: "CPU_Usage"
2014-09-17 17:22:22 [17640] [0] *** Timeout while processing Host: "centcshdb" Service: "Memory_Usage"
2014-11-06 11:15:10 [32623] [0] *** Timeout while processing Host: "centcshdb" Service: "Page_File_Usage"
2014-12-19 06:19:29 [1788] [0] *** Timeout while processing Host: "centcshdb" Service: "Ping"
[root@nagiosxi ~]#

Code: Select all

[root@nagiosxi ~]# grep centcshdb /usr/local/nagios/var/npcd.log
[root@nagiosxi ~]#

Re: No MSSQL_Lock_Reqests_Per_Sec Performance Graph Data

Posted: Thu Apr 16, 2015 5:07 pm
by abrist
Could you enable the npcd logger as per the FAQ:
http://support.nagios.com/wiki/index.ph ... h_Problems
Wait 15 minutes, and then rerun the grep:

Code: Select all

grep -2 centcshdb /usr/local/nagios/var/npcd.log

Re: No MSSQL_Lock_Reqests_Per_Sec Performance Graph Data

Posted: Mon Apr 20, 2015 1:54 pm
by hillhealthcenter
still no results.

Re: No MSSQL_Lock_Reqests_Per_Sec Performance Graph Data

Posted: Mon Apr 20, 2015 4:15 pm
by tgriep
Could you go to Admin > Manage Config Wizards and post back the version of the MSSQL Server Wizard?
Could you provide a screen capture of the advanced tab for that service so we can see the performance output?

Re: No MSSQL_Lock_Reqests_Per_Sec Performance Graph Data

Posted: Tue Apr 21, 2015 12:23 pm
by hillhealthcenter
Here is the wizard.

Re: No MSSQL_Lock_Reqests_Per_Sec Performance Graph Data

Posted: Tue Apr 21, 2015 12:30 pm
by hillhealthcenter
Here is the MSSQL Lock Requests Advanced tab.
All times are UTC-05:00
Page 1 of 3

Powered by phpBB® Forum Software © phpBB Limited