Database Management

Database maintenance is critical to WebUI health. See the BigFix Capacity Planning Guide for information and tools specific to your platform.

  1. Backups - Backups are an established best practice for database recovery. Every BigFix installation should have suitable backup policies in place to address their recovery needs in the event of failure.
  2. Database Reorganization - With constant use the information in a database can become widely distributed; tables and indexes fragment over time. Use your platform's reorganization tools to reclaim space ensure query efficiency.
  3. Database Statistics - Database statistics ensure that the DBMS optimizer makes wise choices for database access plans. The BigFix databases feature cost based optimizers that use database statistics to determine the most efficient way to run a query. If the statistics are not maintained properly, inefficient query plans will be created and WebUI performance will degrade. Use your platform's tools to maintain these statistics.