Partitioning

The Log Database is segmented into partitions for easier data management. Depending on the time period covered by a report, Forcepoint software may need to query multiple partitions. This may make report generation less efficient.

By default, a new Log Database partition is created when the current partition size reaches 5 GB (3 GB if you use SQL Server Express). (With Standard and Enterprise versions of SQL Server, you can also configure the Log Database to roll over at a specific time interval.)

Review the size and content of the partitions in the database after your system has been installed and receiving data for a few days, then tune the partitioning configuration (rollover size or time period) accordingly.

For information on managing partitions, refer to “Configuring database partition options” in the Administrator Help for your web protection solution.

Note: Due to Microsoft SQL Server restrictions, you are limited to 70 active log database partitions. You may retain more than 70 partitions, but only 70 may be active (enabled) at any one time.