The three usage metrics displayed in the manage capacity screen have built-in KPI formatting and conditional logic for good (green), marginal (yellow), and critical (red) statuses. Depending on the type of datasets (import, DirectQuery) and many other factors (such as usage patterns and query complexity), any of the three resources (CPU, memory, bandwidth) could represent a bottleneck.
For example, a P1 capacity has only 25 GB of RAM and thus will not be suitable for very large import (in-memory) datasets. It's recommended to monitor these metrics and to make adjustments if necessary to ensure users have an acceptable experience in terms of performance and responsiveness.
The usage metrics are driven by hourly time ...
