Policy Management
-
SQL in the City Seattle 2015
Redgate will be hosting another SQL in the City event on the Monday right before the PASS Summit 2015. This is a free all day event that you can take advantage of by coming into town a little early. The event will feature some of the best speakers and SQL Server MVPs in the industry,…
-
Policy Based Management White Paper
Below is a link to a white paper I wrote on Policy Based Management. It serves as a guide to not only explain the technology but also walk you through setting it up and designing some policies. You can expect to learn the following: How to enable PBM How to create a policy The different…
-
Policy Based Management On Change: Prevent not available
Policy Based Management has 4 evaluation modes and if you are not already familiar with them you can go HERE to get more information. Today I want to talk about the “On Change: Prevent” mode and why you don’t always see it as an option. The options you see available are dependent on the facets…
-
SQLRally Dallas Slides
I was fortunate enough to get to present not 1 but 2 sessions at SQLRally 2012 in Dallas last week. As a core organizer of the event, this really made it a special week to present twice and see it all come together. My first session was a community choice pick. The second session I got…
-
Setup Alerts for PBM
PBM raises errors for policy violations. We can create alerts on those errors to be notified of policy violations. In order to setup alerts on these errors there are three prerequisites. Note that violations for the “On Demand” evaluation mode do not raise errors. A policy must be set to “Enabled” to raise an error,…
-
See if Auto Create Statistics is enabled using PBM
We will walk through creating a policy to evaluate the status of “Auto Create Statistics” on our server named “File2”. First we need to open SQL Server Management Studio and connect to our server. Then we need to enable Policy Management by expanding the Management node, right clicking on Policy Management, and selecting Enable. You…
-
Import MS Best Practice Policies
Let’s take a look at how to import the Microsoft Best Practice Policies into your Policy Based Management Server. You can also import policies that you have exported from other servers. The Microsoft Best Practice Policies are a great place to start learning what you can do with PBM, by simply importing them and inspecting their…
-
PBM On Schedule Mode
Let’s take a look out how to schedule policy evalution using the PBM On Schedule mode. Start by double clicking on the policy of your choice. Next we need to change the evaluation mode to On Schedule. As soon as you make this change you will notice a red warning appear at the top of the dialog…
-
PBM Evaluation Methods
There are four different ways we can evaluate policies against servers in our environment. These methods are all manual and I will cover how to automate them in another post. This is just a quick list to show your available options, and where they are located. We can evaluate a single policy against a single instance by…
-
PBM Evaluation Modes
PBM has four evaluation modes that provide us with flexibility in the way we evaluate policies against our SQL instances. Here are the options and what we can use them for: On Demand – This is a manual policy evaluation. Policies in this mode can only be evaluated by performing a policy evaluation in SSMS. On Schedule…