IManagedInstancesOperations.ListByManagedInstanceWithHttpMessagesAsync Method

Reference

Definition

Namespace:: Microsoft.Azure.Management.Sql

Assembly:: Microsoft.Azure.Management.Sql.dll

Package:: Microsoft.Azure.Management.Sql v3.1.0-preview

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Get top resource consuming queries of a managed instance.

public System.Threading.Tasks.Task<Microsoft.Rest.Azure.AzureOperationResponse<Microsoft.Rest.Azure.IPage<Microsoft.Azure.Management.Sql.Models.TopQueries>>> ListByManagedInstanceWithHttpMessagesAsync (string resourceGroupName, string managedInstanceName, int? numberOfQueries = default, string databases = default, string startTime = default, string endTime = default, string interval = default, string aggregationFunction = default, string observationMetric = default, System.Collections.Generic.Dictionary<string,System.Collections.Generic.List<string>> customHeaders = default, System.Threading.CancellationToken cancellationToken = default);

abstract member ListByManagedInstanceWithHttpMessagesAsync : string * string * Nullable<int> * string * string * string * string * string * string * System.Collections.Generic.Dictionary<string, System.Collections.Generic.List<string>> * System.Threading.CancellationToken -> System.Threading.Tasks.Task<Microsoft.Rest.Azure.AzureOperationResponse<Microsoft.Rest.Azure.IPage<Microsoft.Azure.Management.Sql.Models.TopQueries>>>

Public Function ListByManagedInstanceWithHttpMessagesAsync (resourceGroupName As String, managedInstanceName As String, Optional numberOfQueries As Nullable(Of Integer) = Nothing, Optional databases As String = Nothing, Optional startTime As String = Nothing, Optional endTime As String = Nothing, Optional interval As String = Nothing, Optional aggregationFunction As String = Nothing, Optional observationMetric As String = Nothing, Optional customHeaders As Dictionary(Of String, List(Of String)) = Nothing, Optional cancellationToken As CancellationToken = Nothing) As Task(Of AzureOperationResponse(Of IPage(Of TopQueries)))

Parameters

resourceGroupName: 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.

managedInstanceName: String

The name of the managed instance.

numberOfQueries: Nullable<Int32>

How many 'top queries' to return. Default is 5.

databases: String

Comma separated list of databases to be included into search. All DB's are included if this parameter is not specified.

startTime: String

Start time for observed period.

endTime: String

End time for observed period.

interval: String

The time step to be used to summarize the metric values. Default value is PT1H. Possible values include: 'PT1H', 'P1D'

aggregationFunction: String

Aggregation function to be used, default value is 'sum'. Possible values include: 'avg', 'min', 'max', 'stdev', 'sum'

observationMetric: String

Metric to be used for ranking top queries. Default is 'cpu'. Possible values include: 'cpu', 'io', 'logIo', 'duration', 'dtu'

customHeaders: Dictionary<String,List<String>>

The headers that will be added to request.

cancellationToken: CancellationToken

The cancellation token.

Returns

Task<AzureOperationResponse<IPage<TopQueries>>>

Exceptions

CloudException

Thrown when the operation returned an invalid status code

SerializationException

Thrown when unable to deserialize the response

ValidationException

Thrown when a required parameter is null

Applies to