Databases Reference
In-Depth Information
You also worked through detailed examples demonstrating how to implement Policy-Based
Management in order to provide an organization-wide coni guration and reporting solution.
Next, you looked at some Microsoft tools for managing SQL Server, including the cloud-based ser-
vice System Center Advisor, for coni guration and patching guidance; and the on-premise enterprise
monitoring solution, System Center Operations Manager, for operational monitoring and alerting.
Finally, you saw that there are numerous ways to achieve the same result in your monitoring
efforts. For example, this chapter demonstrated the methods required to dei ne a check for the
last recent good backup using Policy-Based Management or System Center Operations Manager.
Understanding the strengths of these tools and comparisons such as this should help you select the
right tool for the job for SQL Server manageability.
The most important concept of manageability in SQL Server 2012 is that it is made easier by
these tools, and developing good manageability habits is the best way to ensure the health of your
environment.
Search WWH ::




Custom Search