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.