Go to All Forums

Monitoring SQL server without agent

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.

Like (3) Reply
Replies (1)

Re: Monitoring SQL server without agent

by Gibu

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.

Like (0) Reply

Was this post helpful?