Model for performance

Describes the performance guidelines and best practices to use while mapping your tenants.

  • Identify complex workloads and direct them to their own VW to segregate them.

  • Avoid making separate copies of data for different users and instead apply column masking/hashing and/or row level filtering, to create sanitized data extracts.

  • Look at the peak spilled metrics in the query profiles and depending on the value, increase the data cache size and lower the scratch space (SCRATCH_LIMIT) to cache more data for better performance.