vCenter

 View Only
  • 1.  SQL 2005 on W2K3 R2 (32 Bits) not being monitored

    Posted Jan 10, 2007 10:49 AM
    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


  • 2.  RE: SQL 2005 on W2K3 R2 (32 Bits) not being monitored

    Posted Jan 13, 2007 06:31 PM
    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