I run a small company network (90 users) and a offsite data center which houses our production application. In both sites we have the usual mix of web servers, database servers, domain controllers, file servers, Exchange servers, etc. All Microsoft shop. For monitoring both sites, we have been looking for an application monitoring tool. I have been evaluating Microsoft SCOM 2007 R2 but I have not been very happy with the product. It's slow, unreliable, and does not have a intuitive interface. Seems like I would need to take a full course just to get started. However when it does work, the application diagnostics that SCOM provides are very detailed and useful.
I have also been evaluating Solarwinds Orion, which has a fantastic interface and intuitive architecture, but seems to have stemmed from network infrastructure monitoring and is not as detailed on the application side.
Does anyone have any recommendations for something in between? We want to monitor IIS, MS SQL Server, Active Directory, and general server health. Thanks in advance.