Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Reporting Administration > Log Database administration settings > Configuring database partition options
Configuring database partition options
Administrator Help | Forcepoint Web Security and Forcepoint URL Filtering | v8.5.x
Related topics:
Use the Database Rollover Configuration section of the Settings > Reporting > Log Database page to specify when you want the Log Database to create a new database partition (roll over), where database partitions are stored, and how large partitions are. Also create new partitions manually, rather than waiting for the planned rollover, and review all database partitions available for reporting.
Refer to the Growth Rates and Sizing chart at the bottom of the Database Rollover Configuration section for average daily database partition size over time. This may be helpful in planning for future growth, determining how frequently to create new partitions, and in setting partition size and growth options.
*
Use the drop-down list under the chart to configure the Time period displayed. (The time period is based on the partition creation date; not the dates that the partition spans.) You can display partitions created in the last 1 week, 1 month, 3 months, 6 months, or show all available partitions.
Note that when a longer time period is selected, each partition may appear as a small dot on the chart.
*
Indicate whether or not to Show chart legend. When displayed, the legend indicates which partitions (by name) are mapped in the chart.
The legend is only available when the chart includes 20 or fewer partitions for the selected time period.
*
Select a section of the chart to view it more closely. Click Zoom Out or Reset Chart to reduce the level of detail shown.
For more help with database sizing, see Log Database sizing guidance.
To manage database rollover and growth:
1.
Next to Roll over every, indicate how often you want a new partition to be created.
*
The size limit can be set as follows:
*
SQL Server Standard or Enterprise: 100-1,000,000 MB, default 5000
*
Microsoft SQL Server Express: 100-5000 MB, default 3000
*
 
Note 
When a new partition database is created, the partition is automatically enabled for use in reporting.
2.
a.
Specify the File Path for creating both the Data and Log files for new database partitions.
b.
Under Init Size set the initial file size for both the Data and Log files that make up new database partitions.
*
SQL Server Standard or Enterprise: Data file initial size 50-500,000 MB, default 2000; Log file initial size 50-250,000 MB, default 100
*
SQL Server Express: Data file initial size 50-5000 MB, default 100; Log file initial size 50-4000 MB, default 100
 
Note 
c.
Under Growth, set the increment by which to increase the size of a partition's Data and Log files when additional space is required.
*
SQL Server Standard or Enterprise: Data file growth 100-500,000 MB, default 500; Log file size 1-250,000 MB, default 100
*
SQL Server Express: Data file growth 1-1000 MB, default 100; Log file size 1-1000 MB, default 100
3.
If you want to create a partition the next time the ETL job runs (see Web protection reporting database jobs), rather than waiting for the next automatic rollover, click Manually Create Partition. This process usually takes a few minutes.
*
To have the new partition use changes made on the Log Database page, click OK and Save and Deploy before clicking Manually Create Partition.
*
4.
Use the Available Partitions list to review the partitions available for reporting. The list shows the dates covered, as well as the size and name of each partition.
The number of Available Partitions that can be included in the list is limited to 500. A SQL Server error may occur if you have more than 500 standard logging partitions in your Log Database.
Mark the check box next to a partition name, and use the buttons below the list to determine whether the partition's data is used in or excluded from reports, or to delete the partition.
*
Click Enable to include a selected partition's data in reports. You must enable at least one partition for reporting.
A maximum of 70 partitions can be enabled on one time.
*
Click Disable to exclude a selected partition's data from reports.
Together, the Enable and Disable options allow you to manage how much data is analyzed during report generation and speed report processing.
*
Click Delete to remove a partition that is no longer needed. The partition is actually deleted the next time the nightly database maintenance job runs.
Only enabled partitions can be deleted. To delete a disabled partition, first enable it, then delete it.
 
Warning 
Deleting obsolete partitions minimizes the number of partitions in the Log Database, which improves database and reporting performance. Use this Delete option to delete individual partitions as needed. See Configuring Log Database maintenance options if you prefer to delete older partitions according to a schedule.
5.
Click OK to cache your changes. Changes are not implemented until you click Save and Deploy.

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Reporting Administration > Log Database administration settings > Configuring database partition options
Copyright 2018 Forcepoint. All rights reserved.