Is Microsoft deliberately hiding useful metrics for monitoring the performance of SQL? In the metrics section of the Azure portal, I can only find very vague and unhelpful numbers like "% data IO" and "% log IO". These are way too abstract and are essentially meaningless for our purposes.
I'd like to see the throughput rates in bytes/sec. And the number of IOPS. And the latencies on those IOPS.
Any help would be greatly appreciated. I am using single databases (provisioned) with vCore licensing. I realize that there is resource governance going on that is limiting my performance in terms of memory and I/O. However, without being able to review the performance characteristics of the currently provisioned database, it is impossible to determine how much of an upgrade we need to get to our desired goals.
I have read a number of articles, but none of them are helpful in telling me how to get to the throughput, IOPS, or latencies.
Any help would be appreciated.