vCenter

 View Only
  • 1.  Agentless SQL monitoring

    Posted Oct 15, 2007 08:12 PM
    Other then the agentless SNMP or a script monitor, is there a way to utilize the SQL monitors in an agentless mode?

    ex:

    Hyperic --> Proxy Agent --> SQL Server


    I'm sure the document is around but I have yet to find it with the search function.

    Additional info:
    Proxy Agent - 3.1.1-EE
    Sigar 1.4.0.4

    Message was edited by: Testing


  • 2.  RE: Agentless SQL monitoring

    Posted Oct 24, 2007 01:45 AM
    > Other then the agentless SNMP or a script monitor, is
    > there a way to utilize the SQL monitors in an
    > agentless mode?
    >
    > ex:
    >
    > Hyperic --> Proxy Agent --> SQL Server
    >
    >
    > I'm sure the document is around but I have yet to
    > find it with the search function.

    Yes, this is possible by creating the SQL resources by hand on the agent you want to monitor the remote SQL server. The only requirement is that agent is able to make a JDBC connection to the server you want to monitor. We only auto-discover databases if the agent is installed locally on the database machine, however service discovery will work fine once the JDBC connection parameters are entered if the database is monitored remotely.

    Are you looking to monitor a specific database type (e.g. Postgres, MySQL, etc) or do you just want to issue SQL queries?

    -Ryan


  • 3.  RE: Agentless SQL monitoring

    Posted Oct 25, 2007 04:00 PM
    Looking to remotely monitor MSSQL and Oracle.

    Initially just thinking to use a group of SQL queries.