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

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

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.
server_name Required	str The name of the server.
database_name Required	str The name of the database.
advisor_name Required	str The name of the Database Advisor.

Keyword-Only Parameters

Name	Description
cls	callable A custom type or function that will be passed the direct response

Returns

Type	Description
Advisor	Advisor, or the result of cls(response)

Exceptions

Type	Description
HttpResponseError

list_by_database

Gets a list of database advisors.

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

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.
server_name Required	str The name of the server.
database_name Required	str The name of the database.
expand	str The child resources to include in the response. Default value: None

Keyword-Only Parameters

Name	Description
cls	callable A custom type or function that will be passed the direct response

Returns

Type	Description
list[Advisor]	list of Advisor, or the result of cls(response)

Exceptions

Type	Description
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

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.
server_name Required	str The name of the server.
database_name Required	str The name of the database.
advisor_name Required	str The name of the Database Advisor.
parameters Required	Advisor The requested advisor resource state.

Keyword-Only Parameters

Name	Description
cls	callable A custom type or function that will be passed the direct response

Returns

Type	Description
Advisor	Advisor, or the result of cls(response)

Exceptions

Type	Description
HttpResponseError

Attributes

models

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