Viewing the Database Memory Requirements (SRC CLI)

Purpose

View the SSR database memory requirements. Use this command to calculate the required memory size based on the defined schema and the projected maximum number of rows to be stored in each table.

Action

To view information about the database memory requirements:

user@host> show database memory-requirement table (subscriber-sessions | service-sessions) maximum-number-of-rows maximum-number-of-rows use-running-configuration use-running-configuration

Set the use-running-configuration option to use the schema defined in running configuration to calculate the table size. Otherwise, use the schema in the current CLI configuration

To view information about the subscriber sessions table, specify the subscriber sessions table and the maximum projected number of rows to be stored in the table. For example:

user@host> show database memory-requirement table subscriber-sessions maximum-number-of-rows 1000000

To view information about the service sessions table, specify the service sessions table and the maximum projected number of rows to be stored in the table. For example:

user@host> show database memory-requirement table service-sessions maximum-number-of-rows 1000000

The output displays the minimum data memory, maximum data memory, and index memory. The minimum data memory is the amount of data memory required if all variable length columns are empty. The maximum data memory is the amount of data memory required if all variable length columns are in their full length.

root@host> show database memory-requirement table subscriber-sessions maximum-number-of-rows 1000000 
Memory Requirement
Table Name               subscriber-sessions
Minimum Data Memory (MB) 398
Maximum Data Memory (MB) 608
Index Memory (MB)        77

Related Documentation