At some point, you are going to need a notification system for a range of events that occur in your servers, even if it is only a warning of low disk space. I will show how you can  set up temporary alerts for any WMI eventsto fit what you need. You will see how to create your own monitoring server to perform some basic alerts (low disk space - mount points too, services stops) and some specific alerts using WMI for Server Events (SQL Server Only). Alerts as if Database Mirroring State Changes, DDL modifications, Changes in the Server Configurations Settings and others. The Idea is we have a central monitoring server that recieve the events from the monitored servers in the EventViewer and the an email is send to the right people. We will see what is WMI, WMI for Server Events, WQL, Event Query Language and the cmdlet Register-WMIEvent

(no tags)