Recommendation for free event monitoring software

I'm seeking recommendations for free / open event monitoring tools. HPOV costs continue to multiply like so many wet gremlins, and we've had enough.

There are some interesting suggestions in this article and the subsequent comments, but before I set about trying many of these I'm sure you all have found a few that you like that may or may not be in this list. There is also this thread, but we're really shooting for a no-cost solution.

The primary requirements are:

• Perform a basic ping test

• Check the up-state of the SQL Server service.

• Send an email alert if 1 or 2 fail.

• Works as far back as Sql Server 2005 - present. (This is where PBM comes up a bit short)

Additional desired-not-required functionality would be:

• Ability to pass a synthetic transaction, which if failed triggers an alert.

• Ability to measure said transaction for duration, not just completion, and alert if a threshold is exceeded.

• Alert on other measurable (logged) events.

Thanks much for any recommendations!

Edit: Currently investigating SpiceWorks

Polymon from codeplex is ideal for my uses. I'm monitoring not just server availability, but sql agent jobs success, a host of perfmon data, SQL locking/blocking, db and filesystem freespace, and a whole lot more.

It has a very nice Powershell interface, so any Powershell script you can imagine, it will run on the schedule you specify and then alert/notify/take action as you direct.

It requires a SQL2005 or greater instance to hold its db, but it can monitor any version of SQL. (Using Powershell, I even have it monitoring CACHE on AIX.)

No cost besides having an available SQL 2005 server to host the db.

StackExchange Database Administrators Q#22344, answer score: 4