ManagedDatabaseQueriesOperations Class

Warning

DO NOT instantiate this class directly.

Instead, you should access the following operations through

SqlManagementClient's

<xref:managed_database_queries> attribute.

Constructor

ManagedDatabaseQueriesOperations(*args, **kwargs)

Methods

get	Get query by query id.
list_by_query	Get query execution statistics by query id.

get

Get query by query id.

async get(resource_group_name: str, managed_instance_name: str, database_name: str, query_id: str, **kwargs: Any) -> ManagedInstanceQuery

Parameters

Name	Description
resource_group_name Required	str The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal. Required.
managed_instance_name Required	str The name of the managed instance. Required.
database_name Required	str The name of the database. Required.
query_id Required	str Required.

Returns

Type	Description
ManagedInstanceQuery	ManagedInstanceQuery or the result of cls(response)

Exceptions

Type	Description
HttpResponseError

list_by_query

Get query execution statistics by query id.

list_by_query(resource_group_name: str, managed_instance_name: str, database_name: str, query_id: str, start_time: str | None = None, end_time: str | None = None, interval: str | QueryTimeGrainType | None = None, **kwargs: Any) -> AsyncItemPaged[QueryStatistics]

Parameters

Name	Description
resource_group_name Required	str The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal. Required.
managed_instance_name Required	str The name of the managed instance. Required.
database_name Required	str The name of the database. Required.
query_id Required	str Required.
start_time	str Start time for observed period. Default value is None. Default value: None
end_time	str End time for observed period. Default value is None. Default value: None
interval	str or QueryTimeGrainType The time step to be used to summarize the metric values. Known values are: "PT1H" and "P1D". Default value is None. Default value: None

Returns

Type	Description
AsyncItemPaged[QueryStatistics]	An iterator like instance of either QueryStatistics or the result of cls(response)

Exceptions

Type	Description
HttpResponseError

Attributes

models

models = <module 'azure.mgmt.sql.models' from 'C:\\ToolCache\\Python\\3.12.10\\x64\\Lib\\site-packages\\py2docfx\\venv\\venv268\\Lib\\site-packages\\azure\\mgmt\\sql\\models\\__init__.py'>