1. Home
  2. On-premises 5.2
  3. Guides
  4. Tours
  5. Concepts
  6. Tools
    1. Alert Editor
    2. Alias Sync Tool
    3. Analyzer
    4. Apache Parquet Merge Tool
    5. Avro Extractor Tool
    6. Business Schema Designer
    7. Business Schema Manager
    8. Cluster Management Console
      1. SSO for Tenant from CMC
      2. Pause Load Jobs from CMC
      3. Use Warmup Mode
      4. Inspector Tool
      5. Notebook Add-on
      6. CMC Logs Manager
      7. CMC Monitoring
      8. CMC Scheduler
      9. CMC Tenants Manager
    9. Command Line Interface
    10. Content Manager
    11. Dashboard Filters Manager
    12. Data Agent
    13. Data APIs for External Notebooks
    14. Data Manager
    15. Formula Builder
    16. Formula Validation Tool
    17. Inspector Tool
    18. Join Editor
    19. Load Job Viewer
    20. Model Update Viewer
    21. Notebook Editor
    22. Profile Manager
    23. Public API
    24. Query Plan Viewer
    25. Scheduler
    26. Schema Designer
    27. Schema Diagram Viewer
    28. Schema Manager
    29. Schema Wizard
    30. Security Manager
    31. Table Editor
    32. Tenant Management Tool
    33. Versioning Migration Tool
  7. References
  8. Integrations
  9. Data applications
  10. Releases

Use Warmup Mode

About Warmup Mode

Warmup Mode affects how the Analytics Service loads schema data into memory when starting up and can be set as the default tenant configuration or for a specific tenant configuration.

The Warmup Mode options include:  

  • None: Only loads on demand, and does not pre-load the columns.  None works best for small deployments with ad-hoc queries.
  • Last used columns: Loads the previous state prior to shutting down the loader and analytics services.
  • Business view columns: Loads all columns referenced in the business schema views in the analytics service only.
  • Most Used Dashboard Columns: Loads most-used dashboard columns using a pre-specified percentage of memory.
  • All: Pre-loads all columns into memory. All works best when you need to support ad-hoc queries, if there are no business schemas in place, and when the time between the analytics service startup and dashboard usage is significant.

Warmup Mode with Most Used Dashboard Columns

When Most Used Dashboard Column is selected, you can choose the Maximum (%) of Memory Intended for Warmup. The default value is 20%, but you can choose any value between 0% - 75%.

To enable this option as the default tenant configuration in the CMC:

  1. In the navigation bar, select Clusters.
  2. Select a cluster name from the cluster list.
  3. Select Cluster Configurations.
  4. Select the Default Tenant Configurations tab.
  5. In the left pane, select Advanced.
  6. In the right pane, select Most Used Dashboard Column from the Warmup Mode dropdown.
  7. Enter a value between 0 and 75 in Maximum (%) of Memory Intended for Warmup.
  8. Select Save.

To enable this option for a specific tenant configuration in the CMC:

  1. In the navigation bar, select Clusters.
  2. In the cluster list, select a cluster name.
  3. In the canvas tabs, select the Tenants tab.
  4. In the tenant list, select Configure for the given tenant.
  5. In the left pane, select Advanced.
  6. In the right pane, select Most Used Dashboard Column from the Warmup Mode dropdown.
  7. Enter a value between 0 and 75 in Maximum (%) of Memory Intended for Warmup.
  8. Select Save.

Restart your analytic services for changes to take effect and load the chosen columns.