October 20, 2003 at 5:29 am
Hi All,
Coul any one help me.
How to monitor SQL Server availability (say database is Up or Down)?
Is there any OS level setting to make by that an administrator can be informed by email or some thing like that ?
Thank you in advance.
Ganga..
G R Konda
October 20, 2003 at 7:49 am
Schedule a job at OS level with "Schedule Tasks" from control panel to monitor whether SQL Server service MSSQLSERVER running regularly with tools such scm.exe from SQL Server, sc.exe from resource kit or psservice.exe from http://www.systernals.com.
October 20, 2003 at 10:46 am
It's a tough issue because you have to define "up". If the server is running, but someone can't connect to the server (network issue), is the database "up"?
I'd script something that checks from another machine. Lots of tools do this from Openview ($$$$) to Servers Alive ($), or a simple "osql" script. But set something up remotely to check.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 22, 2003 at 12:37 am
Sorry for the delayed response.
Thank you both, for the response.
Ganga..
G R Konda
G R Konda
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply