Chapter 7. Practical Uses of Policy-Based Management
Like any feature, Policy-Based Management is useful only if it can help you in solving real-world problems. In this chapter, we'll show you how you can benefit from using specific policies in your SQL Server environment. First, we'll present a sample list of checks commonly performed by DBAs. Then we'll look at custom and predefined policies that will perform those checks for you automatically.
A DBA Checklist
Every DBA has a list of items to check on a daily, weekly, and monthly basis. For example, you may want to ensure the following conditions are true for each of your servers:
Databases have sufficient free space.
Transaction logs were backed up.
SQL Server Agent is running.
All SQL Server Agent ...
Get Pro SQL Server 2008 Policy-Based Management now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
