Share via


IManagedInstancesOperations.ListByManagedInstanceWithHttpMessagesAsync Method

Definition

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

Exceptions

Thrown when the operation returned an invalid status code

Thrown when unable to deserialize the response

Thrown when a required parameter is null

Applies to