Azure Performance Query - Documentation

Overview

This document provides an overview of the Azure Performance Query endpoint. It allows you to analyze and understand the performance of your Azure resources.

Key Features

• Performance Metrics: Displays key performance metrics such as CPU utilization, memory usage, network I/O, and disk I/O.
• Resource Monitoring: Provides detailed insights into the performance of individual resources.
• Custom Queries: Allows you to create custom queries to tailor the data displayed.
• Filtering & Sorting: Robust filtering and sorting options.

Data Structure

The endpoint returns a JSON object with the following keys:

• resource: The name of the resource (e.g., VM, Storage Account).
• metadata: A JSON object containing additional details about the resource.
• metrics: An array of performance metrics, including:
• CPU Utilization: A percentage representing the CPU utilization of the resource.
• Memory Usage: The amount of memory used by the resource.
• Network I/O: The amount of data transferred over the network.
• Disk I/O: The amount of data read/written to the disk.
• Query Time: The time it takes to execute the query.

Query Parameters

The /msdn/documentation/azure/performance/query-performance endpoint accepts the following query parameters:

• resource: (Required) The name of the resource to query.
• query: (Optional) A SQL query to execute.
• limit: (Optional) The maximum number of results to return.
• offset: (Optional) The starting index for the results.
• format: (Optional) The format of the output data.

Example Query

Example: Retrieve the CPU utilization of all VMs:

                {
                    "resource": "VM",
                    "metadata": {
                        "status": "Running"
                    },
                    "metrics": [
                        {
                            "CPU Utilization": 0.8
                        }
                    ]
                }
            

Documentation

For more detailed documentation, please refer to the Azure Performance Query documentation: [https://learn.microsoft.com/en-us/azure/performance-query/](https://learn.microsoft.com/en-us/azure/performance-query/)