HarryH (11/14/2008)
I appreciate the detailed reply, Marios. You certainly seem to understand the position I am in - looking at SCOM with a view to using it for some useful SQL monitoring and thinking,"What the #$@^!???" etc...
SCOM 2007 seems like a beast... but from what you are saying -- and your article backs this up -- it is a beast that can be tamed, if approached with the right attitude.
I too have used Idera and SQL Sentry plus a number of other tools, which tend to have nice GUIs, but I have often resorted to writing my own scripts for monitoring. And yes, trying to deploy scripts to multiple database servers is a complete pain - especially when every deployment seems to require some kind of customization... so perhaps, as you are saying, the pain of the SCOM 2007 learning curve is worth it for the ability to centrally monitor multiple database servers...
Again thanks for the follow up - I have a better feel for what I am facing now and, perhaps more importantly, appreciate why I should bother... 🙂
I was in your position just a few short months ago, and, believe me, a lot of cursing was involved getting SCOM to work the way I wanted... 😉
Articles like mine and others' before are meant as a roadmap for someone who is just getting into SCOM, so that their learning curve is hopefully shorter and less painful than mine.
Experimentation with various SCOM features is key, as MS has done a deplorable job documenting SCOM as a tool. It really is to their disadvantage, because had they better promoted it to the DBA community, I bet you their revenues from the product would rise drastically. Hell, they should be paying me commission, for doing the job their sales and marketing people should be doing and are not!!
Feel free to post any SCOM-related questions to this site (and this thread), and if I or one of several others here know the answer, we will respond promptly.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]