DatabaseAdvisorsOperations Class

DatabaseAdvisorsOperations 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.

Inheritance

builtins.object

DatabaseAdvisorsOperations

Constructor

DatabaseAdvisorsOperations(client, config, serializer, deserializer)

Parameters

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

models

Alias to model classes used in this operation group.

Methods

get	Gets a database advisor.
list_by_database	Gets a list of database advisors.
update	Updates a database advisor.

get

Gets a database advisor.

get(resource_group_name: str, server_name: str, database_name: str, advisor_name: str, **kwargs: Any) -> _models.Advisor

Parameters

resource_group_name

str

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.

server_name

str

Required

The name of the server.

database_name

str

Required

The name of the database.

advisor_name

str

Required

The name of the Database Advisor.

cls

callable

A custom type or function that will be passed the direct response

Returns

Advisor, or the result of cls(response)

Return type

Advisor

Exceptions

HttpResponseError

list_by_database

Gets a list of database advisors.

list_by_database(resource_group_name: str, server_name: str, database_name: str, expand: Optional[str] = None, **kwargs: Any) -> List[_models.Advisor]

Parameters

resource_group_name

str

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.

server_name

str

Required

The name of the server.

database_name

str

Required

The name of the database.

expand

str

default value: None

The child resources to include in the response.

cls

callable

A custom type or function that will be passed the direct response

Returns

list of Advisor, or the result of cls(response)

Return type

list[Advisor]

Exceptions

HttpResponseError

update

Updates a database advisor.

update(resource_group_name: str, server_name: str, database_name: str, advisor_name: str, parameters: _models.Advisor, **kwargs: Any) -> _models.Advisor

Parameters

resource_group_name

str

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.

server_name

str

Required

The name of the server.

database_name

str

Required

The name of the database.

advisor_name

str

Required

The name of the Database Advisor.

parameters

Advisor

Required

The requested advisor resource state.

cls

callable

A custom type or function that will be passed the direct response

Returns

Advisor, or the result of cls(response)

Return type

Advisor

Exceptions

HttpResponseError

Attributes

models

models = <module 'azure.mgmt.sql.models' from 'C:\\hostedtoolcache\\windows\\Python\\3.9.13\\x64\\lib\\site-packages\\azure\\mgmt\\sql\\models\\__init__.py'>