I wanted to know if there are any automated methods/ways to check for SQL server instance alerts.
I guess, in SQL server 2008, central management servers can be used for this by implementing Policy Management.
I need to know how would I receive an alert (possibly email) when a SQL server 2000/2005 instance goes down.
any sort of help is highly appreciated!!!...
thanks a lot, Mandar Alawani INDIA
asked Feb 26, 2010 at 07:07 AM in Default
In addition to matt's suggestion, I use Idera's tools (specifically SQLdm)
With this you can also monitor your SQL server via blackberrys or Windows Mobile devices.
Oh, and no! I dont work for Idera ;-) I just rate their tools
answered Feb 26, 2010 at 07:14 AM
you could probably knock something together with PowerShell, just to query to make sure the service is running. In fact here you go, I just found this in my favourites http://www.simple-talk.com/sql/database-administration/powersmo-at-work-part-2/
answered Feb 26, 2010 at 08:17 AM
@Mandar - You have to be careful with "is down". "down" to IT will be different (IMO) to the end users.
SQL Server service stopped, server un available or network down is generally what IT are interesting, but to the users and a DBA things like blocking, high cpu, poor perf'ing queries will be what causes "users" to see a disruption to a Service/Application.
A good monitoring tool will provide all this.
When setting up a tool (like idera), make sure you install the services and DB on a different server/db server.
answered Feb 26, 2010 at 09:05 AM