For SQL Server, we now have over 100+ rules baked into this service representing the collective knowledge of CSS SQL Engineers worldwide on common customer issues. Have you ever wanted to know what the CSS teams knows based on common issues reported by customers? That is what SCA is all about. Providing you that knowledge in the form of a cloud-based service.
Give this a try on your SQL Server and look at the advice that is presented. We specifically baked in rules (called alerts) with the intention of helping you prevent problems before they happen.
Take a look through my previous blog posts above on this topic for some examples. What is incredibly powerful about this service is:
Once you install, it just “runs”
You view your alerts through a web portal so can do this anywhere
As part of the service we capture configuration change history (i.e. a problem started but what changed?)
We keep the rules “fresh” by updating the service each month but you don’t have to do anything. The service automatically pulls in these new rules for you.
I look forward to any comments you post to this blog regarding your experiences with it.