Backstory:
We have an azure sql elastic pool with several databases in it and around 750GB of data. We've been having some sporadic outages which correlate with the metric "Sql Server process core percent" hitting a max of 100% for a duration.
Normally, the process core percent metric trends with the cpu percentage metric pretty closely. However, during these outage scenarios, the correlation is actually inverse. The CPU metric (max aggregation) bottoms out, when the process core percent (max aggregation) is peaking.
If I use average for the aggregation, the trend of them correlating is maintained.
TL;DR: What would cause the "Sql Server process core" metric to max out independent of the CPU metric in an Azure Sql Elastic Pool?