Recommended Elastic Pools - List Metrics

Reference

Service:: SQL Database

API Version:: 2014-04-01

Returns recommended elastic pool metrics.

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/recommendedElasticPools/{recommendedElasticPoolName}/metrics?api-version=2014-04-01

URI Parameters

Name	In	Required	Type	Description
recommendedElasticPoolName	path	True	string	The name of the recommended elastic pool to be retrieved.
resourceGroupName	path	True	string	The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName	path	True	string	The name of the server.
subscriptionId	path	True	string	The subscription ID that identifies an Azure subscription.
api-version	query	True	string	The API version to use for the request.

Responses

Name	Type	Description
200 OK	RecommendedElasticPoolListMetricsResult	OK

Examples

Get recommended elastic pool metrics

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6852/providers/Microsoft.Sql/servers/sqlcrudtest-2080/recommendedElasticPools/sqlcrudtest-2080_pool1/metrics?api-version=2014-04-01

import com.azure.core.util.Context;

/** Samples for RecommendedElasticPools ListMetrics. */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2014-04-01/examples/RecommendedElasticPoolListMetrics.json
     */
    /**
     * Sample code: Get recommended elastic pool metrics.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void getRecommendedElasticPoolMetrics(com.azure.resourcemanager.AzureResourceManager azure) {
        azure
            .sqlServers()
            .manager()
            .serviceClient()
            .getRecommendedElasticPools()
            .listMetrics("sqlcrudtest-6852", "sqlcrudtest-2080", "sqlcrudtest-2080_pool1", Context.NONE);
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Sample response

Status code:: 200

{
  "value": [
    {
      "dateTime": "2017-07-24T12:00:00Z",
      "dtu": 0.01758824557626567,
      "sizeGB": 0.921875
    },
    {
      "dateTime": "2017-07-25T12:00:00Z",
      "dtu": 0.018937532104510685,
      "sizeGB": 0.921875
    }
  ]
}

Definitions

Name	Description
RecommendedElasticPoolListMetricsResult	Represents the response to a list recommended elastic pool metrics request.
RecommendedElasticPoolMetric	Represents recommended elastic pool metric.

RecommendedElasticPoolListMetricsResult

Represents the response to a list recommended elastic pool metrics request.

Name	Type	Description
value	RecommendedElasticPoolMetric[]	The list of recommended elastic pools metrics.

RecommendedElasticPoolMetric

Represents recommended elastic pool metric.

Name	Type	Description
dateTime	string	The time of metric (ISO8601 format).
dtu	number	Gets or sets the DTUs (Database Transaction Units). See https://azure.microsoft.com/documentation/articles/sql-database-what-is-a-dtu/
sizeGB	number	Gets or sets size in gigabytes.

Share via