ManagedInstanceResource.GetTopQueriesAsync Method

Definition

Namespace:

Azure.ResourceManager.Sql

Assembly:

Azure.ResourceManager.Sql.dll

Package:

Azure.ResourceManager.Sql v1.2.1

Overloads

GetTopQueriesAsync(ManagedInstanceResourceGetTopQueriesOptions, CancellationToken)	Get top resource consuming queries of a managed instance. Request Path: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/topqueries Operation Id: ManagedInstances_ListByManagedInstance Default Api Version: 2022-08-01-preview Resource: ManagedInstanceResource
GetTopQueriesAsync(Nullable<Int32>, String, String, String, Nullable<QueryTimeGrainType>, Nullable<AggregationFunctionType>, Nullable<SqlMetricType>, CancellationToken)	Get top resource consuming queries of a managed instance. Request Path: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/topqueries Operation Id: ManagedInstances_ListByManagedInstance

GetTopQueriesAsync(ManagedInstanceResourceGetTopQueriesOptions, CancellationToken)

Source:

ManagedInstanceResource.cs

Get top resource consuming queries of a managed instance.

• Request Path: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/topqueries
• Operation Id: ManagedInstances_ListByManagedInstance
• Default Api Version: 2022-08-01-preview
• Resource: ManagedInstanceResource

public virtual Azure.AsyncPageable<Azure.ResourceManager.Sql.Models.TopQueries> GetTopQueriesAsync (Azure.ResourceManager.Sql.Models.ManagedInstanceResourceGetTopQueriesOptions options, System.Threading.CancellationToken cancellationToken = default);

abstract member GetTopQueriesAsync : Azure.ResourceManager.Sql.Models.ManagedInstanceResourceGetTopQueriesOptions * System.Threading.CancellationToken -> Azure.AsyncPageable<Azure.ResourceManager.Sql.Models.TopQueries>
override this.GetTopQueriesAsync : Azure.ResourceManager.Sql.Models.ManagedInstanceResourceGetTopQueriesOptions * System.Threading.CancellationToken -> Azure.AsyncPageable<Azure.ResourceManager.Sql.Models.TopQueries>

Public Overridable Function GetTopQueriesAsync (options As ManagedInstanceResourceGetTopQueriesOptions, Optional cancellationToken As CancellationToken = Nothing) As AsyncPageable(Of TopQueries)

Parameters

options

ManagedInstanceResourceGetTopQueriesOptions

A property bag which contains all the parameters of this method except the LRO qualifier and request context parameter.

cancellationToken

CancellationToken

The cancellation token to use.

Returns

AsyncPageable<TopQueries>

An async collection of TopQueries that may take multiple service requests to iterate over.

GetTopQueriesAsync(Nullable<Int32>, String, String, String, Nullable<QueryTimeGrainType>, Nullable<AggregationFunctionType>, Nullable<SqlMetricType>, CancellationToken)

Source:

ManagedInstanceResource.cs

Get top resource consuming queries of a managed instance.

• Request Path: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/topqueries
• Operation Id: ManagedInstances_ListByManagedInstance

public virtual Azure.AsyncPageable<Azure.ResourceManager.Sql.Models.TopQueries> GetTopQueriesAsync (int? numberOfQueries = default, string databases = default, string startTime = default, string endTime = default, Azure.ResourceManager.Sql.Models.QueryTimeGrainType? interval = default, Azure.ResourceManager.Sql.Models.AggregationFunctionType? aggregationFunction = default, Azure.ResourceManager.Sql.Models.SqlMetricType? observationMetric = default, System.Threading.CancellationToken cancellationToken = default);

abstract member GetTopQueriesAsync : Nullable<int> * string * string * string * Nullable<Azure.ResourceManager.Sql.Models.QueryTimeGrainType> * Nullable<Azure.ResourceManager.Sql.Models.AggregationFunctionType> * Nullable<Azure.ResourceManager.Sql.Models.SqlMetricType> * System.Threading.CancellationToken -> Azure.AsyncPageable<Azure.ResourceManager.Sql.Models.TopQueries>
override this.GetTopQueriesAsync : Nullable<int> * string * string * string * Nullable<Azure.ResourceManager.Sql.Models.QueryTimeGrainType> * Nullable<Azure.ResourceManager.Sql.Models.AggregationFunctionType> * Nullable<Azure.ResourceManager.Sql.Models.SqlMetricType> * System.Threading.CancellationToken -> Azure.AsyncPageable<Azure.ResourceManager.Sql.Models.TopQueries>

Public Overridable Function GetTopQueriesAsync (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 Nullable(Of QueryTimeGrainType) = Nothing, Optional aggregationFunction As Nullable(Of AggregationFunctionType) = Nothing, Optional observationMetric As Nullable(Of SqlMetricType) = Nothing, Optional cancellationToken As CancellationToken = Nothing) As AsyncPageable(Of TopQueries)

Parameters

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

Nullable<QueryTimeGrainType>

The time step to be used to summarize the metric values. Default value is PT1H.

aggregationFunction

Nullable<AggregationFunctionType>

Aggregation function to be used, default value is 'sum'.

observationMetric

Nullable<SqlMetricType>

Metric to be used for ranking top queries. Default is 'cpu'.

cancellationToken

CancellationToken

The cancellation token to use.

Returns

AsyncPageable<TopQueries>

An async collection of TopQueries that may take multiple service requests to iterate over.