Databases Reference
In-Depth Information
TABLE 16-1:
PBM Conditions
DATA AND LOG FILE SIZE
GROWTH INCREMENT
<100MB
100MB
>100MB and <10GB
500MB
>10GB
1GB
When dei ning each policy, it's possible to choose an evaluation mode that determines the effect of
the policy; Table 16-2 summarizes the options.
TABLE 16-2:
Policy Evaluation Modes
EVALUATION MODE
DESCRIPTION
On Demand
Policies are evaluated manually by a DBA, as required.
On Schedule
A pre-defi ned schedule controls when policies are evaluated.
On Change Prevent
The policy will actively prevent an action that could cause a condition to
evaluate false (only where rollback is possible).
On Change Log Only
Allows a change that will cause a false evaluation, but logs the change
Getting Started with PBM
This section describes the steps required to get a PBM deployment up and running. Three phases are
required: dei ning a condition, creating a policy, and evaluating this policy against a local machine.
The following steps establish a condition and policy:
1.
Launch SQL Server Management Studio and select Management
➪
Policy Management.
2.
Right-click on Conditions and choose New Condition.
3.
Type the condition name
Auto Close Disabled
.
4.
Using the Facet drop-down list, Select Database Performance.
5.
In the Expression pane, select the i eld name @AutoClose, verify that the operator shows the
equals sign (=), and choose the value False (as shown in Figure 16-1). Click OK.
Search WWH ::
Custom Search