SQL elastic pools usage details

Question

Hello Team,

I am facing an issue I try to fetch the usage percentage of the SQL elastic pools,

PS C:\Users\gaurav.singh> Get-AzSqlElasticPool -ResourceGroupName $resourceGroupName -ServerName $serverName -ElasticPoolName $elasticPoolName | Select-Object -ExpandProperty StorageMBPercentageUsage
Select-Object: Property "StorageMBPercentageUsage" cannot be found.

Can you please help me with the right command that can show the used space or percentage of the Azure Elastic Pools

Answer 1

Hi Gaurav Singh:

Thanks for reaching out to Microsoft Q&A.

Did you try the below commands, which includes the 'azmetric' ?

Get-AzSqlElasticPool -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01" | Get-AzMetric -TimeGrain 0:5:0 -MetricName storage_percent

You can get the below parameters from this metric.

cpu_percent, physical_data_read_percent, log_write_percent, dtu_consumption_percent, storage_percent

Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.