Performance Tuning Guide

From QPR ProcessAnalyzer Wiki
Revision as of 23:15, 18 October 2023 by Ollvihe (talk | contribs)
Jump to navigation Jump to search

This guide contains information how to get the best performance out of QPR ProcessAnalyzer system while taking into account incurred infrastructure costs. Performance optimization is entirely different in Snowflake and in-memory models, so there are separate chapters for them.

Snowflake models

Snowflake scaling

  • Larger warehouse
  • Multi-cluster warehouses

In-memory models

Server resources

  • Memory
  • Processors
  • Database