Help understand server timings timeline in dax studio
After facing some performance bottlenecks I started looking into the Server Timings page in Dax Studio to better understand what's going on. As you can see this expression took more than 45 seconds. We then look at the individual rows and try to se which ones take the most time and try to optimize that part. Question 1) There is a duration column, but summarizing those values only gives us the SE queries duration? Question 2) If we look closer at rows 86 and forwards we see there is a huge leap from the timings indicator even though the last operation only took 1 ms. What's going on here? Is it the Formula Engine cranking for dear life without any traces? How would i go about to optimize this..? Question 3) Do you recognize this charcteristic of the timeline that we have two huge operations more or less and can explain in general what could be poorly configured/usual suspects...?
