ManagedInstanceResource.GetTopQueriesAsync Method
Definition
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.
Overloads
| GetTopQueriesAsync(ManagedInstanceResourceGetTopQueriesOptions, CancellationToken) |
Get top resource consuming queries of a managed instance.
|
| GetTopQueriesAsync(Nullable<Int32>, String, String, String, Nullable<QueryTimeGrainType>, Nullable<AggregationFunctionType>, Nullable<SqlMetricType>, CancellationToken) |
Get top resource consuming queries of a managed instance.
|
GetTopQueriesAsync(ManagedInstanceResourceGetTopQueriesOptions, CancellationToken)
- Source:
- ManagedInstanceResource.cs
- 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
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
An async collection of TopQueries that may take multiple service requests to iterate over.
Applies to
GetTopQueriesAsync(Nullable<Int32>, String, String, String, Nullable<QueryTimeGrainType>, Nullable<AggregationFunctionType>, Nullable<SqlMetricType>, CancellationToken)
- Source:
- ManagedInstanceResource.cs
- 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
- 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
An async collection of TopQueries that may take multiple service requests to iterate over.
Applies to
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Azure SDK for .NET