we have had a single user in our dedicated SQL pool spike the CPU to 100% on her own previously. We believe this is due to her query having multiple subqueries and being in a medium resource class. However, we cannot tell the execution plan. We typically operate at 500 DWU, which has 20 concurrency slots with the medium rc getting two slots.
If the query has, what looks like 4 or 5 subqueries, should we expect that this query to take a total of 10 concurrency slots? Also, how do we look at the execution plan? It doesn't seem the same as normal SQL.
Thank you!
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…