We've been having some problems with our SharePoint environment going down lately. Suspicion is an issue with the SQL server (CPU and memory maxed out, as yet unknown whether it's a customization to SharePoint or a problem with the SQL box), but we want to use SCOM to identify issues before our users do and send alerts.
Of course, we don't want to miss useful alerts in a sea of inconsequential ones.
I don't know much about SCOM, my understanding is that there is a set of templates. Is there a short, short list of essential, easily configured alert templates, geared towards communication with SQL, that are recommended? Is there a way to ping the sites or a file within the sites that will alert us if something is unavailable for over x seconds?
If we see that we're still getting errors without notification, naturally we can adjust later.
Thanks,
Scott