LinkedIn | FaceBook | Twitter
If you have multiple systems in your organization, and especially if you use multiple kinds of systems (such as exchange, Forefront and SQL Server, for instance) then you might want to check out Microsoft System Center, and in particular, System Center Operations Manager.You might know this product by it's old name of "MOM" (Microsoft Operations Manager), but it's a new animal now. I'm working on the "Management Packs" and "Health Models" for SQL Server for this product.
Basically it allows you to define a model of your system, including SQL Server. You can then use the Health Model to describe when it is working well, not working well, or failing. The interesting thing is that it comes with descriptions of why something happened as well as what you can do about it - sort of a "consultant in a box". I'll be blogging more about how you can use it as I develop these packs and models.
PingBack from http://www.biosensorab.org/2008/02/14/system-center-operations-manager-and-sql-server/
If you have multiple systems in your organization, and especially if you use multiple kinds of systems
Blake sends me this:
Microsoft also has a great addition for System Center Operations Manager and SQL Server:
SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log alerts and provides associated knowledge articles with additional user details, possible causes, and suggested resolutions. The Management Pack discovers Database Engines, Database Instances, and Databases and can optionally discover Database File and Database File Group objects.
"The Road to Know Where"