How to get maximum usage of cpu percentage for Appserviceplan and for sql databases using powershell?

badri srinath 1 Reputation point
2022-04-23T03:39:51.223+00:00

Need powershell script to get metrics of azure resources.

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,797 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Takahito Iwasa 4,841 Reputation points MVP
    2022-04-23T22:56:44.01+00:00

    Hi, @badri srinath

    You can use the Az-PowerShell module Get-AzMetric to access resource metrics.

    Below is a sample getting the SQL Database metrics.
    https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/monitor-and-scale-database-powershell

    The Get-AzMetric reference below also gets the App Service metrics.
    https://learn.microsoft.com/en-us/powershell/module/az.monitor/get-azmetric?view=azps-7.4.0

    If this doesn't work, please tell me why.
    If you can't do it well with this, ask additional questions. We will always help you.

    0 comments No comments