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:
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 :
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
FileServer discovery took 0.02
2014-02-28 07:38:10,752 INFO Running
runtime autodiscovery for ProcessServer
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
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
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
Hi Rahul,
Hyperic 4.6.6 doesn't support MSSQL 2012. I recommend to upgrade your environment to 5.8.x
Enjoy