Thank you guys for your responses. I've ended up evaluating 5 products (SCOM, Idera, Spotlight, SQL Sentry, Oracle Grid with SQL plugin). So far, Spotlight stands-out...the challenge is the cost...

The are a number of focus areas , however the following are key: (1) Problem detection and resolution via email and sms alerts and automated action tasks (2) Capacity planning...

Thank you for your prompt response Bitbucket, I found it very useful, especially the technet link you provided.

Here are some of the features, I've included:

Improved Productivity and efficiency - Management...