Summary
In this chapter, we started by introducing performance tuning and discovered that performance tuning is a process similar to troubleshooting. Next, we learned what workload groups are and how to configure them. We created an example workload group that restricted the number of requests that members from a specific AAD group can make. We discovered the three components that are required to use workload groups are the request classification policy, which is responsible for assigning requests to workload groups, the workload groups themselves, and the workload group policies that allow us to apply restrictions to requests, such as rate limiting.
Next, we discovered how to manage our cluster performance by managing the hot cache from the data plane. By managing the cache at the data plane, we can allow database administrators to tune performance, without giving them access to the management plane.
Next, we introduced the .show queries
and .show commands
KQL management commands...