ManagedInstancesOperationsExtensions.ListByManagedInstance Method

Definition

Get top resource consuming queries of a managed instance.

public static Microsoft.Rest.Azure.IPage<Microsoft.Azure.Management.Sql.Models.TopQueries> ListByManagedInstance (this Microsoft.Azure.Management.Sql.IManagedInstancesOperations operations, 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);
static member ListByManagedInstance : Microsoft.Azure.Management.Sql.IManagedInstancesOperations * string * string * Nullable<int> * string * string * string * string * string * string -> Microsoft.Rest.Azure.IPage<Microsoft.Azure.Management.Sql.Models.TopQueries>
<Extension()>
Public Function ListByManagedInstance (operations As IManagedInstancesOperations, 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) As IPage(Of TopQueries)

Parameters

operations
IManagedInstancesOperations

The operations group for this extension method.

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'

Returns

IPage<TopQueries>

Applies to