Introducing performance tuning
Before we jump into workload groups, let's spend a few moments thinking about performance tuning in general. In general, performance should not be an issue, given that ADX has been designed and optimized to be a big data service that is highly scalable and fast. As you ingest more and more data and allow more users and applications to query your clusters, you may experience some performance degradation. Therefore, it is important to beware of performance tuning concepts and what features ADX provides to help tune performance when the time comes.
Like troubleshooting, which we discussed in Chapter 9, Monitoring and Troubleshooting Azure Data Explorer, performance tuning can be considered as a process. The goal of performance tuning is to identify bottlenecks, troubleshoot their causes, and apply the features that are available to us, such as workload groups, cache policies, and so on, to eliminate bottlenecks. It is also important to understand...