Hyperic agent report false Availability problem of the server

[eliran]

Hi all,
I am getting alerts about Availability of the server but when i am checking manualy the server it's ok.

My hyperic agent is: 4.0.2 and the hyperic server is: 4.0.1

here some liens from the agent log file that looks suspicious.
2009-02-01 02:16:15,266 WARN [ScheduleThread] [ScheduleThread] Collection of metric: 'JBoss 4.0 HQ Internals:hyperic.jmx:name=HQInternal:MetricsCollectedPerMinute:java.naming.provider.url=jnp%3A//127.0.0.1%3A2099,java.naming.security.principal=%java.naming.security.principal%,java.naming.security.credentials=' took: 374952ms
2009-02-01 02:17:04,072 WARN [ScheduleThread] [ScheduleThread] Collection of metric: 'SQL Query:sqlquery:select count(1) from transactions t (nolock) inner join OrderLines ol (nolock) on ol.orderNumber %3D t.orderNumber where ol.orderDate >%3D dateadd(mi%2C-30%2Cgetdate()):availability:jdbcDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver,jdbcUrl=jdbc%3Amicrosoft%3Asqlserver%3A//10.50.3.84%3A1433;databasename%3DOberon,jdbcUser=hyperic,jdbcPassword=***********' took: 44510ms
2009-02-01 02:20:30,968 WARN [ScheduleThread] [ScheduleThread] Collection of metric: 'JBoss 4.0 HQ Internals:hyperic.jmx:name=HQInternal:MetricsCollectedPerMinute:java.naming.provider.url=jnp%3A//127.0.0.1%3A2099,java.naming.security.principal=%java.naming.security.principal%,java.naming.security.credentials=' took: 30653ms
2009-02-01 02:21:09,775 WARN [ScheduleThread] [ScheduleThread] Collection of metric: 'SQL Query:sqlquery:select count(1) from transactions t (nolock) inner join OrderLines ol (nolock) on ol.orderNumber %3D t.orderNumber where ol.orderDate >%3D dateadd(mi%2C-30%2Cgetdate()):availability:jdbcDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver,jdbcUrl=jdbc%3Amicrosoft%3Asqlserver%3A//10.50.3.84%3A1433;databasename%3DOberon,jdbcUser=hyperic,jdbcPassword=***********' took: 33464ms
2009-02-01 02:25:40,709 WARN [ScheduleThread] [ScheduleThread] Collection of metric: 'SQL Query:sqlquery:select count(1) from transactions t (nolock) inner join OrderLines ol (nolock) on ol.orderNumber %3D t.orderNumber where ol.orderDate >%3D dateadd(mi%2C-30%2Cgetdate()):availability:jdbcDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver,jdbcUrl=jdbc%3Amicrosoft%3Asqlserver%3A//10.50.3.84%3A1433;databasename%3DOberon,jdbcUser=hyperic,jdbcPassword=***********' took: 39182ms
2009-02-01 02:31:53,505 WARN [ScheduleThread] [ScheduleThread] Collection of metric: 'JBoss 4.0 HQ Internals:hyperic.jmx:name=HQInternal:MetricsCollectedPerMinute:java.naming.provider.url=jnp%3A//127.0.0.1%3A2099,java.naming.security.principal=%java.naming.security.principal%,java.naming.security.credentials=' took: 109314ms

Please help me to solve this problem

[excowboy]

Hi,

it's not the time offset problem, is it ? This is a common problem and has been discussed here in the forums multiple times.

Cheers,
Mirko

[admin]

That doesn't appear to be the problem.. The SQL Query plugin runs in-line with other metric collection. (Unlike plugins that use Collectors). Any idea on why those queries are taking so long? They are probably causing Availability to be collected late.

-Ryan