How can I monitor an SQL server without installing an agent. Even running a simple query to just verify the server is up and running would be enough for our purpose.
We are using a external SQL server from a hosting provider where we do not have access to the OS, so installing the 24x7 agent is not an option.
We need a clarification.
>>Even running a simple query to just verify the server is up and running would be enough for our purpose.
I assume you will still need a server on the same network to run the query remotely.
Have you looked at the option to run a SQL query by writing a "Site24x7 Custom Plugin" that does this querying?
DB Server : SQLSvr-1
DB Server : SQLSvr-2
DB Server : SQLSvr-3
Dedicated Host : Svr4
Install Site24x7 Agent on Svr4 and write 3 plugins that connect and monitor each of the 3 database servers.
Please let us know if this makes sense.