I recently spent some time investigating the Business Activity Monitoring (BAM) capabilities available with Microsoft BizTalk 2006 R2.
Here are some additional resource links that I've found of interest:
Zenoss (Commercial Open Source Application, Systems & Network Monitoring)
2007 review, Zenoss Core
Killer open source monitoring tools (Cacti is mentioned)
Leverage Nagios with plug-ins you write