ManagedDatabaseQueriesOperations Class
ManagedDatabaseQueriesOperations operations.
You should not instantiate this class directly. Instead, you should create a Client instance that instantiates it for you and attaches it as an attribute.
Constructor
ManagedDatabaseQueriesOperations(client, config, serializer, deserializer)Parameters
| Name | Description |
|---|---|
|
client
Required
|
Client for service requests. |
|
config
Required
|
Configuration of service client. |
|
serializer
Required
|
An object model serializer. |
|
deserializer
Required
|
An object model deserializer. |
Variables
| Name | Description |
|---|---|
|
models
|
Alias to model classes used in this operation group. |
Methods
| get |
Get query by query id. |
| list_by_query |
Get query execution statistics by query id. |
get
Get query by query id.
get(resource_group_name: str, managed_instance_name: str, database_name: str, query_id: str, **kwargs: Any) -> _models.ManagedInstanceQueryParameters
| Name | Description |
|---|---|
|
resource_group_name
Required
|
The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal. |
|
managed_instance_name
Required
|
The name of the managed instance. |
|
database_name
Required
|
The name of the database. |
|
query_id
Required
|
|
Keyword-Only Parameters
| Name | Description |
|---|---|
|
cls
|
A custom type or function that will be passed the direct response |
Returns
| Type | Description |
|---|---|
|
ManagedInstanceQuery, or the result of cls(response) |
Exceptions
| Type | Description |
|---|---|
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 | '_models.QueryTimeGrainType' | None = None, **kwargs: Any) -> Iterable['_models.ManagedInstanceQueryStatistics']Parameters
| Name | Description |
|---|---|
|
resource_group_name
Required
|
The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal. |
|
managed_instance_name
Required
|
The name of the managed instance. |
|
database_name
Required
|
The name of the database. |
|
query_id
Required
|
|
|
start_time
|
Start time for observed period. Default value: None
|
|
end_time
|
End time for observed period. Default value: None
|
|
interval
|
The time step to be used to summarize the metric values. Default value: None
|
Keyword-Only Parameters
| Name | Description |
|---|---|
|
cls
|
A custom type or function that will be passed the direct response |
Returns
| Type | Description |
|---|---|
|
An iterator like instance of either ManagedInstanceQueryStatistics or the result of cls(response) |
Exceptions
| Type | Description |
|---|---|
Attributes
models
models = <module 'azure.mgmt.sql.models' from 'C:\\ToolCache\\Python\\3.11.9\\x64\\Lib\\site-packages\\py2docfx\\venv\\venv223\\Lib\\site-packages\\azure\\mgmt\\sql\\models\\__init__.py'>