Help us improve your experience.

Let us know what you think.

Do you have time for a two-minute survey?

Navigation
Guide That Contains This Content
[+] Expand All
[-] Collapse All

    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
    

    Modified: 2015-06-23