Configuring database rollover options
The top of the Log Database Options section displays the name of the active Log Database and a Refresh link. Click Refresh to update the information shown on the Log Database page. Be sure you save your settings before you click Refresh, because any unsaved changes on the page will be cleared.
Use the Database Rollover Options section of the page to specify when you want the Log Database to create a new database partition, a process called a rollover.
Use the Roll over every option to indicate whether database partitions should roll over based on size (MB) or date (weeks or months).
- For size-based rollovers, select MB and specify the number of megabytes the database must reach for the rollover to begin, from 100–10240 MB (default is 5120).
- For date-based rollovers, select either weeks or months as the unit of measure, and specify how many full calendar weeks (from 1–52) or months (from 1–12) to keep in a database partition before
a new one is created.Note:
If the rollover begins during a busy part of the day, performance may slow during the rollover process.
To avoid this possibility, some environments choose to set the automatic rollover to a long time period or large maximum size. Then, they perform regular manual rollovers to prevent the automatic rollover from occurring.
See Creating database partitions for information on manual rollovers.
Extremely large individual partitions are not recommended. Reporting performance can slow if data is not divided into multiple, smaller partitions.
When a new database partition is created, reporting is automatically enabled for the partition (see Enabling database partitions).
Click OK to activate changes to the database rollover options.