SQL Server Policy-Based Management

This blog is dedicated to Policy-Based Management introduced in SQL Server 2008

Browse by Tags

Tagged Content List
  • Blog Post: Generate the List of All Available Facets and Their Properties

    Our colleague Jens Suessmeyer in Germany has figured out how to generate the list of all facets and their properties. He has posted the list on his blog. Below is the code snippet from Jens: foreach ( FacetInfo info in PolicyStore .Facets) {      Console .WriteLine(info.Name);     ...
  • Blog Post: Policy Evaluation Modes

    I hosted a PBM break out session in Microsoft MVP Summit 2009 in March. One feedback I got is that the rules for what evaluation modes a policy support are obtuse. I thought that would be a good topic to cover in the blog. In PBM, users can specify the “Evaluation Mode” for a policy, as shown in the...
  • Blog Post: Defining Complex Server "Health" Policies in SQL2K8

    Bart Duncan (a dev on the manageability team and one of the masterminds behind the Management Data Warehouse and Data Collector feature in SQL Server 2008) has a blog posting where he walks through using PBM to author a complex server "health" policy.
  • Blog Post: Out-Of-Box Policies

    SQL Server 2008 includes several predefined policies. These are generally associated with best practices and overtime the rules from the Best Practices Analyzer will be implemented as policies for PBM. A number of these have already been implemented and are available to you in one of two forms: First...
  • Blog Post: Policy Categories

    Policy categories have two purposes in SQL2K8: 1) organization of policies and 2) policy scope. In this posting we'll explore creating categories for each of these purposes. Creating Categories There are two ways to create a category: 1) the Manage Categories dialog and 2) The Policy Properties dialog...
  • Blog Post: Using PBM Against SQL2K and SQL2K5

    We get this question a lot: can I use PBM against a SQL2K & SQL2K5 instances. The quick answer is yes but in a limited fashion. PBM is ultimately based on SMO (SQL Server Management Objects) and SMO supports SQL2K, SQL2K5, and SQL2K8. PBM relies on some changes to the DB engine which are not available...
Page 1 of 1 (6 items)