Monitor premium capacities
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access