Database is getting too large

If the size of your database is pushing the limits of your storage, you may consider adjusting some settings.

Procedure

  1. If you do not use the Page Performance reports, you do not need to collect the Path Statistics. You can disable the Path Statistics collection to save significant database space.
    • See "Discover Settings" in the HCL Discover Administration Manual.
  2. In SQL Server Management Studio, check the Recovery Model setting for each database. If the Recovery Model is set to Full, the databases and their log files can grow larger.