VMware Cloud Community
saturno_hyperic
Contributor
Contributor

SQL 2005 on W2K3 R2 (32 Bits) not being monitored

Hi Everyone

I have one server running W2K3 R2 (32 bits) with SQL 2005 with I'm not able to monitor...

After reading the thread: http://communities.vmware.com/thread/346775?tstart=0 and executing the suggested command, I can't determine exactly what is going on...

Once this server is running a named instance (SQL2005), I've already created a new server in Hyperic as suggested with the name MSSQL$SQL2005 and turned on "Auto-Discover Databases?" without any luck also.

Any help is very appreciated.

The output of the command is:

D:\hq-agent-2.7.6\agent-2.7.6\jre\bin>java -jar ..\..\pdk\lib\hq-product.jar -p
mssql -m discover
3 servers detected

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Server: SQL MsSQL 2005 MSSQL.3 [C:\Program Files\Microsoft SQL Server\MSSQL.3\Re
porting Services\]
config...
product..{service_name=MSSQL$MSSQL.3}
metric...{}
control..{}
cprops...{version=9.00.2047.00}
[ERROR] PluginDiscoverer - MsSQL 2005 Win32-->org.hyperic.hq.product.PluginExcep
tion: Error getting pdh data for 'MSSQL$MSSQL.3': The specified object could not
be found on the computer
[1]-NESTED-EXCEPTION:
org.hyperic.sigar.win32.Win32Exception: The specified object could not be foun
d on the computer <org.hyperic.hq.product.PluginException: Error getting pdh dat
a for 'MSSQL$MSSQL.3': The specified object could not be found on the computer
[1]-NESTED-EXCEPTION:
org.hyperic.sigar.win32.Win32Exception: The specified object could not be foun
d on the computer>org.hyperic.hq.product.PluginException: Error getting pdh data
for 'MSSQL$MSSQL.3': The specified object could not be found on the computer
[1]-NESTED-EXCEPTION:
org.hyperic.sigar.win32.Win32Exception: The specified object could not be foun
d on the computer
at org.hyperic.hq.plugin.mssql.MsSQLDetector.discoverServices(MsSQLDetec
tor.java:276)
at org.hyperic.hq.product.ServerDetector.discoverResources(ServerDetecto
r.java:191)
at org.hyperic.hq.product.util.PluginDiscoverer.runtimeScan(PluginDiscov
erer.java:589)
at org.hyperic.hq.product.util.PluginDiscoverer.start(PluginDiscoverer.j
ava:307)
at org.hyperic.hq.product.util.PluginDumper.testDiscovery(PluginDumper.j
ava:1065)
at org.hyperic.hq.product.util.PluginDumper.invoke(PluginDumper.java:431
)
at org.hyperic.hq.product.util.PluginMain.main(PluginMain.java:273)
Caused by: org.hyperic.sigar.win32.Win32Exception: The specified object could no
t be found on the computer
at org.hyperic.sigar.win32.Pdh.pdhGetInstances(Native Method)
at org.hyperic.sigar.win32.Pdh.getInstances(Pdh.java:85)
at org.hyperic.hq.plugin.mssql.MsSQLDetector.discoverServices(MsSQLDetec
tor.java:250)
... 6 more


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Server: SQL MsSQL 2005 MSSQL.2 [C:\Program Files\Microsoft SQL Server\MSSQL.2\OL
AP\]
config...
product..{service_name=MSSQL$MSSQL.2}
metric...{}
control..{}
cprops...{version=9.00.2047.00}
[ERROR] PluginDiscoverer - MsSQL 2005 Win32-->org.hyperic.hq.product.PluginExcep
tion: Error getting pdh data for 'MSSQL$MSSQL.2': The specified object could not
be found on the computer
[1]-NESTED-EXCEPTION:
org.hyperic.sigar.win32.Win32Exception: The specified object could not be foun
d on the computer <org.hyperic.hq.product.PluginException: Error getting pdh dat
a for 'MSSQL$MSSQL.2': The specified object could not be found on the computer
[1]-NESTED-EXCEPTION:
org.hyperic.sigar.win32.Win32Exception: The specified object could not be foun
d on the computer>org.hyperic.hq.product.PluginException: Error getting pdh data
for 'MSSQL$MSSQL.2': The specified object could not be found on the computer
[1]-NESTED-EXCEPTION:
org.hyperic.sigar.win32.Win32Exception: The specified object could not be foun
d on the computer
at org.hyperic.hq.plugin.mssql.MsSQLDetector.discoverServices(MsSQLDetec
tor.java:276)
at org.hyperic.hq.product.ServerDetector.discoverResources(ServerDetecto
r.java:191)
at org.hyperic.hq.product.util.PluginDiscoverer.runtimeScan(PluginDiscov
erer.java:589)
at org.hyperic.hq.product.util.PluginDiscoverer.start(PluginDiscoverer.j
ava:307)
at org.hyperic.hq.product.util.PluginDumper.testDiscovery(PluginDumper.j
ava:1065)
at org.hyperic.hq.product.util.PluginDumper.invoke(PluginDumper.java:431
)
at org.hyperic.hq.product.util.PluginMain.main(PluginMain.java:273)
Caused by: org.hyperic.sigar.win32.Win32Exception: The specified object could no
t be found on the computer
at org.hyperic.sigar.win32.Pdh.pdhGetInstances(Native Method)
at org.hyperic.sigar.win32.Pdh.getInstances(Pdh.java:85)
at org.hyperic.hq.plugin.mssql.MsSQLDetector.discoverServices(MsSQLDetec
tor.java:250)
... 6 more


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Server: SQL MsSQL 2005 MSSQL.1 [C:\Program Files\Microsoft SQL Server\MSSQL.1\MS
SQL]
config...
product..{service_name=MSSQL$MSSQL.1}
metric...{}
control..{}
cprops...{version=9.00.2047.00}
[ERROR] PluginDiscoverer - MsSQL 2005 Win32-->org.hyperic.hq.product.PluginExcep
tion: Error getting pdh data for 'MSSQL$MSSQL.1': The specified object could not
be found on the computer
[1]-NESTED-EXCEPTION:
org.hyperic.sigar.win32.Win32Exception: The specified object could not be foun
d on the computer <org.hyperic.hq.product.PluginException: Error getting pdh dat
a for 'MSSQL$MSSQL.1': The specified object could not be found on the computer
[1]-NESTED-EXCEPTION:
org.hyperic.sigar.win32.Win32Exception: The specified object could not be foun
d on the computer>org.hyperic.hq.product.PluginException: Error getting pdh data
for 'MSSQL$MSSQL.1': The specified object could not be found on the computer
[1]-NESTED-EXCEPTION:
org.hyperic.sigar.win32.Win32Exception: The specified object could not be foun
d on the computer
at org.hyperic.hq.plugin.mssql.MsSQLDetector.discoverServices(MsSQLDetec
tor.java:276)
at org.hyperic.hq.product.ServerDetector.discoverResources(ServerDetecto
r.java:191)
at org.hyperic.hq.product.util.PluginDiscoverer.runtimeScan(PluginDiscov
erer.java:589)
at org.hyperic.hq.product.util.PluginDiscoverer.start(PluginDiscoverer.j
ava:307)
at org.hyperic.hq.product.util.PluginDumper.testDiscovery(PluginDumper.j
ava:1065)
at org.hyperic.hq.product.util.PluginDumper.invoke(PluginDumper.java:431
)
at org.hyperic.hq.product.util.PluginMain.main(PluginMain.java:273)
Caused by: org.hyperic.sigar.win32.Win32Exception: The specified object could no
t be found on the computer
at org.hyperic.sigar.win32.Pdh.pdhGetInstances(Native Method)
at org.hyperic.sigar.win32.Pdh.getInstances(Pdh.java:85)
at org.hyperic.hq.plugin.mssql.MsSQLDetector.discoverServices(MsSQLDetec
tor.java:250)
... 6 more
Reply
0 Kudos
1 Reply
saturno_hyperic
Contributor
Contributor

That's fair!
No answers ... Nobody's using this software with other languages than English. So it seems.

But I think I have the answer, in case somebody wants to know:

- Hyperic seems to fall into Windows performance monitor counters language, so I think it is not able to monitor other OS / Applications languages. At least for now.

Portuguese thanks to all that have read the question.
(I think my English is not so bad, so I think the question is clear enough :))
[]

Message was edited by: saturno
Reply
0 Kudos