Forum Discussion
Helper IPowerBI Premium Capacity Monitor - CPU vs Duration ?
Hi,
I don't know if this is the right board to ask, feel free to move the thread elsewhere.
We installed the PowerBI Premium Capacity Monitor and i'm not sure to understand the "duration" metric and how it differs from the "CPU" metric. I mean that i'm quite sure to know how to reduce CPU usage through optimizing model and complex measure but for Duration?
I also i have a specific case where i don't understand how the data is consumed and what justify huge difference between similar dataset in the duration metric.
Thank you
1 Reply
- lbendlin
Super User
They are both important but duration is more important.
Think of it as a capacity - that is actually what it is called. Your SKU (say, a P2) has a certain capacity, the number of render cores that can be used at the same time. Each of these render cores is available 24 hours in each day. Every event (Direct Query or Mashup) consumes a renderer for a certain duration. During that time nobody else can use the renderer.
That's why controlling duration is much more important than controlling the number of requests. A thousand requests lasting half a second each will not be a problem. A single request lasting 18000 seconds is a big problem as it blocks a renderer for five hours . A small number of long duration requests can very easily bring your capacity to its knees.
