What is the unit used for measuring metrics for an Azure sql database?
I am running a script to get back some metrics for an Azure sql database.
$metrics = Get-AzMetric -ResourceId $databaseResourceId -MetricName "dtu_consumption_percent" - StartTime (Get-Date).AddDays(-100) -EndTime (Get-Date)
$sumOfAverages = 0
foreach ($metric in $metrics.Data) {
foreach ($data in $metric) {
# Add the average value to the sum
$sumOfAverages += $data.Average
}
}
$sumOfAverages
But when I get the $sumOfAverages
it outputs a value of 880.75.
What is that value measured in? It is %, so 8.8075 % of the dtu
is set on the database. So if the DTU is 200, then it only used 8% of it. Is that right?
I have run some scripts to get the value, but do I need the metric?
Read more here: Source link