Skip to main content

Check out Interactive Visual Stories to gain hands-on experience with the SSE product features. Click here.

Skyhigh Security

Summary Cache Page

View settings and status information for the summary table caches.

NOTE: To modify the settings on this page, the database must be online and maintenance jobs cannot be running. When the database is reconnected, changes made to database settings before going offline are retained. If the database goes offline while changes are made in the caches, these changes will not be saved.

Option Definition
Actions

Actions to perform from this page include:

  • Choose Columns — Select which columns to display, and the order they appear. Additional columns include:
    • Average Preload Batch Size — Displays the average size of batches the system has attempted to load.
    • Elapsed Time — Displays the duration of time that has passed since the statistics began calculation.
    • Maximum Entries — Displays the maximum number of entries that can be held in memory.
      NOTE: Default value is different for each row.
    • Maximum Preload Batch Size — Displays the size of the largest batch that the system attempts to load.
    • Time Units Currently Loaded — Displays the number of entry groups that the cache has active.
  • Edit — Opens the Cache Settings dialog box.
  • Refresh — Refreshes the content in the summary cache.
  • Reset Statistics — Resets the hit ratio and elapsed time to zero, and recalculates the Maximum Preload Batch Size and Average Preload Batch Size.

Current Entries

Displays the current number of entries held in the cache.

NOTE: Set to zero by default.

Current Memory Usage

Displays the estimated total amount of memory used by the cache entries.

Hit Ratio

Displays:

  • Ratio between the number of hits versus the sum of the number of hits
  • Number of misses
Show Filter / Hide Filter Displays the Quick find feature, which provides the ability to search for specific text in the Table name column.

Table Name

Displays the name of the summary table in the configured database.

 

  • Was this article helpful?