ManagedDatabaseResource.GetQueryStatisticsAsync Method

Reference

Definition

Namespace:: Azure.ResourceManager.Sql

Assembly:: Azure.ResourceManager.Sql.dll

Package:: Azure.ResourceManager.Sql v1.2.1

Package:: Azure.ResourceManager.Sql v1.3.0-beta.9

Source:: ManagedDatabaseResource.cs

Source:: ManagedDatabaseResource.cs

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.

Get query execution statistics by query id.

Request Path: /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/databases/{databaseName}/queries/{queryId}/statistics
Operation Id: ManagedDatabaseQueries_ListByQuery
Default Api Version: 2020-11-01-preview

public virtual Azure.AsyncPageable<Azure.ResourceManager.Sql.Models.QueryStatistics> GetQueryStatisticsAsync (string queryId, string startTime = default, string endTime = default, Azure.ResourceManager.Sql.Models.QueryTimeGrainType? interval = default, System.Threading.CancellationToken cancellationToken = default);

abstract member GetQueryStatisticsAsync : string * string * string * Nullable<Azure.ResourceManager.Sql.Models.QueryTimeGrainType> * System.Threading.CancellationToken -> Azure.AsyncPageable<Azure.ResourceManager.Sql.Models.QueryStatistics>
override this.GetQueryStatisticsAsync : string * string * string * Nullable<Azure.ResourceManager.Sql.Models.QueryTimeGrainType> * System.Threading.CancellationToken -> Azure.AsyncPageable<Azure.ResourceManager.Sql.Models.QueryStatistics>

Public Overridable Function GetQueryStatisticsAsync (queryId As String, Optional startTime As String = Nothing, Optional endTime As String = Nothing, Optional interval As Nullable(Of QueryTimeGrainType) = Nothing, Optional cancellationToken As CancellationToken = Nothing) As AsyncPageable(Of QueryStatistics)

Parameters

queryId: String

The String to use.

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.

cancellationToken: CancellationToken

The cancellation token to use.

Returns

AsyncPageable<QueryStatistics>

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

Exceptions

ArgumentException

queryId is an empty string, and was expected to be non-empty.

ArgumentNullException

queryId is null.

Applies to

Share via