Databases Reference
In-Depth Information
auto-growth increment varies according to the size of the database. It would be unreasonable to
grow a 10MB log i le by anything more than a few MB. Similarly, it would be unreasonable to grow
a 100GB data i le by anything less than 1GB.
To get started with this policy example, create the four conditions shown in Table 16-3. Figure 16-3
shows values for a medium data check condition.
TABLE 16-3:
Example Autogrow Conditions
CONDITION NAME
FACET
FIELD
OPERATOR
VALUE (KB)
Optimized Autogrow — Small Data
Data File
@Growth
>
5120
Optimized Autogrow — Small Log
Log File
@Growth
>
5120
Optimized Autogrow — Medium Data
Data File
@Growth
>
102400
Optimized Autogrow — Medium Log
Log File
@Growth
>
102400
FIGURE 16-3
Before creating the policies, four further conditions are required that will be used in the target to
ensure that each policy is applied against the correct database (see Figure 16-4). Table 16-4 summa-
rizes the additional conditions required.
Search WWH ::
Custom Search