ManagedInstancesOperationsExtensions.ListByManagedInstance Method

Definition

Namespace:

Microsoft.Azure.Management.Sql

Assembly:

Microsoft.Azure.Management.Sql.dll

Package:

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

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>