Hey there,

If you already have Ops Manager, you're going to have a very difficult time writing something that's better from scratch. If you want something that's very lightweight, consider turning off all the management packs you don't want. For SQL Servers, you should be fine running just the Windows Server and SQL MPs. Also, be sure your Ops Manager environment is patched up (SP1 is out I think) and that you have updated your management packs. Microsoft releases fixes and enhancements for the management packs two or three times per year - the SQL one was updated in November.

Rather than writing a tool from scratch, consider turning off all the features of the SQL Management pack and then slowly read through each item and enable it if you think it's applicable. Each of the Management Packs comes with a Word doc that explains all of the settings. You will end up with a very customized monitoring environment that alerts only on errors YOU care about on YOUR servers that also happens to plug in to a worldclass Enterprise monitoring system. And you didn't even have to write the plumbing yourself.

I don't mean to discourage you from writing your own tool - as a developer with a systems background I definitely feel the urge to do this from time to time. I just think it's really going to be tough for you to write something better than what you could get with the time investment it would take to really optimize an Ops Manager environment (assuming you have the access to do so).