The Database Storage Information screen

The Server Tools Database Storage Information screen provides information about the space and memory taken up by the database on the PolicyCenter server. You can both view and download database storage information from this screen.

The following tables lists the filtering options for the database storage information:

Option

Available 

Description

Include Estimation of Compression Savings for Tables and Indexes

Oracle

SQL Server

If checked, you need to also select the compression level for estimating savings.

Select Compression Level for Estimating Savings

Oracle

SQL Server

Only available if you chose to include estimation of compression savings in the database storage information. Options include:

  • Oracle – Advanced
  • SQL Server – Screen, Row

Collect Index Physical Stats for all tables

SQL Server

If you select Yes, then PolicyCenter includes statistics on all tables in the database.

If you select Specify tables, PolicyCenter includes statistics only on the database tables that you select.

Select Mode for Collecting Index Physical Stats

SQL Server

Options include:

  • None
  • Detailed
  • Limited
  • Sampled

Be aware that if you select the Detailed option without selecting individual tables the report can take a long time to generate.

After setting the desired filtering options, chose one of the following:

  • To see the database storage information on the current PolicyCenter screen, click Display Database Storage Info.
  • To download the database storage information to view later, click Download Database Storage Info.

After you click Display Database Storage Info, the screen shows information at the bottom of the screen, along with a drop-down that you can use to filter the information.