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