admin
Immortal
Immortal

Problem with Hyperic MSSql metrics

Hello,

I installed hyperic agent on my server which is sending all metrics to

HQ. However, MSSQL 2012 metrics are not being sent. Instead it is being

reported as MSSQL 2008 in the Resources. Here is what I see:

     server-hostname-N MsSQL 2008 MSSQLSERVER (MsSQL 2008)

No metrics are available for this resource.

I get this when I go further:

2 Replies
admin
Immortal
Immortal

Hello,

Sorry for the duplicate message

I installed hyperic agent on my server which is sending all metrics to

HQ (vFabric Hyperic 4.6.6). However, MSSQL 2012 metrics are not being

sent. Instead it is being reported as MSSQL 2008 in the Resources. Here

is what I see:

     server-hostname-N MsSQL 2008 MSSQLSERVER (MsSQL 2008)

No metrics are available for this resource.

I get this when I go further:

This resource is turned off or has not been configured properly.

The problem is: Invalid configuration: Error retrieving value:

\SQLServer:Buffer Manager\Stolen pages

Please turn on the server, or fix its Configuration Properties

<http://hyperic.srv.media.net/resource/server/Inventory.do?mode=editConfig&type=2&rid=10633>.

In the agent I get this :

2014-02-28 07:37:53,109 ERROR

Error getting real time measurement: Error retrieving value:

\SQLServer:Buffer Manager\Stolen pages

2014-02-28 07:38:01,641 INFO  Running

runtime autodiscovery for FileServer

2014-02-28 07:38:10,752 INFO 

FileServer discovery took 0.02

2014-02-28 07:38:10,752 INFO  Running

runtime autodiscovery for ProcessServer

2014-02-28 07:38:19,971 INFO 

ProcessServer discovery took 0.02

2014-02-28 07:38:19,971 INFO  Running

runtime autodiscovery for HQ Agent

2014-02-28 07:38:29,271 INFO  HQ

Agent discovery took 0

2014-02-28 07:38:29,271 INFO  Running

runtime autodiscovery for NetworkServer

2014-02-28 07:38:38,490 INFO 

NetworkServer discovery took 0.02

2014-02-28 07:38:38,490 INFO  Running

runtime autodiscovery for MsSQL 2008

2014-02-28 07:38:47,853 INFO  MsSQL

2008 discovery took 0.08

2014-02-28 07:38:47,853 INFO  Running

runtime autodiscovery for WindowsServer

2014-02-28 07:38:57,323 INFO 

WindowsServer discovery took 0

2014-02-28 07:38:57,323 INFO  Running

runtime autodiscovery for Net Services

2014-02-28 07:39:06,637 INFO  Net

Services discovery took 0

2014-02-28 07:39:22,999 WARN  Error

invoking method

org.hyperic.hq.agent.AgentRemoteException: Failed to unschedule metrics

for entity 2:10621: No measurement schedule for: 2:10621

     at

org.hyperic.hq.measurement.agent.server.MeasurementCommandsService.unscheduleMeasurements(MeasurementCommandsService.java:388)

     at

org.hyperic.hq.measurement.agent.server.MeasurementCommandsServer.dispatchCommand(MeasurementCommandsServer.java:162)

     at

org.hyperic.hq.agent.server.CommandDispatcher.processRequest(CommandDispatcher.java:112)

     at

org.hyperic.hq.agent.server.CommandListener.listenLoop(CommandListener.java:191)

     at org.hyperic.hq.agent.server.AgentDaemon.start(AgentDaemon.java:844)

     at

org.hyperic.hq.agent.server.AgentDaemon$RunnableAgent.run(AgentDaemon.java:926)

     at java.lang.Thread.run(Unknown Source)

Can anyone point out the issue please?

Thanks

0 Kudos
admin
Immortal
Immortal

Hi Rahul,

Hyperic 4.6.6 doesn't support MSSQL 2012. I recommend to upgrade your environment to 5.8.x

Enjoy