Databases Reference
In-Depth Information
TABLE 16-5:
Example File Autogrow Policies
POLICY NAME
CHECK CONDITION
AGAINST TARGETS
Database — Log File
Autogrow Amount
Optimized Autogrow —
Small Log
Log Files with KB Growth Type Log
fi l e i n E v e r y D a t a b a s e
Database — Data File
Autogrow Amount
Optimized Autogrow —
Small Data
Data Files with KB Growth Type
File in Every FileGroup in Every
Database
Database — Medium Data
Autogrow
Optimized Autogrow —
Medium Data
Data Files 1GB or greater with KB
fi le in Every FileGroup in Every
Database
Database — Medium Log
Autogrow
Optimized Autogrow —
Medium Log
Log Files 1GB or greater with KB
LogFile in Every database
FIGURE 16-5
Creating these eight conditions and four policies enables the automated policy evaluation to ensure
that small databases have KB growth increments, and databases with data or log i les larger than
1GB have autogrow set to 1GB or larger.
Search WWH ::
Custom Search