VMware Cloud Community
Testing_hyperic
Contributor
Contributor

Agentless SQL monitoring

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
Reply
0 Kudos
2 Replies
admin
Immortal
Immortal

> 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
Reply
0 Kudos
Testing_hyperic
Contributor
Contributor

Looking to remotely monitor MSSQL and Oracle.

Initially just thinking to use a group of SQL queries.
Reply
0 Kudos