azure.mgmt.sql.operations.DatabaseAdvisorsOperations.yml

### YamlMime:PythonClass
uid: azure.mgmt.sql.operations.DatabaseAdvisorsOperations
name: DatabaseAdvisorsOperations
fullName: azure.mgmt.sql.operations.DatabaseAdvisorsOperations
module: azure.mgmt.sql.operations
inheritances:
- builtins.object
summary: '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.'
constructor:
  syntax: DatabaseAdvisorsOperations(client, config, serializer, deserializer)
  parameters:
  - name: client
    description: Client for service requests.
    isRequired: true
  - name: config
    description: Configuration of service client.
    isRequired: true
  - name: serializer
    description: An object model serializer.
    isRequired: true
  - name: deserializer
    description: An object model deserializer.
    isRequired: true
variables:
- description: Alias to model classes used in this operation group.
  name: models
methods:
- uid: azure.mgmt.sql.operations.DatabaseAdvisorsOperations.get
  name: get
  summary: Gets a database advisor.
  signature: 'get(resource_group_name: str, server_name: str, database_name: str,
    advisor_name: str, **kwargs: Any) -> _models.Advisor'
  parameters:
  - name: resource_group_name
    description: 'The name of the resource group that contains the resource. You can

      obtain this value from the Azure Resource Manager API or the portal.'
    isRequired: true
    types:
    - <xref:str>
  - name: server_name
    description: The name of the server.
    isRequired: true
    types:
    - <xref:str>
  - name: database_name
    description: The name of the database.
    isRequired: true
    types:
    - <xref:str>
  - name: advisor_name
    description: The name of the Database Advisor.
    isRequired: true
    types:
    - <xref:str>
  keywordOnlyParameters:
  - name: cls
    description: A custom type or function that will be passed the direct response
    types:
    - <xref:callable>
  return:
    description: Advisor, or the result of cls(response)
    types:
    - <xref:azure.mgmt.sql.models.Advisor>
  exceptions:
  - type: azure.core.exceptions.HttpResponseError
- uid: azure.mgmt.sql.operations.DatabaseAdvisorsOperations.list_by_database
  name: list_by_database
  summary: Gets a list of database advisors.
  signature: 'list_by_database(resource_group_name: str, server_name: str, database_name:
    str, expand: str | None = None, **kwargs: Any) -> List[''_models.Advisor'']'
  parameters:
  - name: resource_group_name
    description: 'The name of the resource group that contains the resource. You can

      obtain this value from the Azure Resource Manager API or the portal.'
    isRequired: true
    types:
    - <xref:str>
  - name: server_name
    description: The name of the server.
    isRequired: true
    types:
    - <xref:str>
  - name: database_name
    description: The name of the database.
    isRequired: true
    types:
    - <xref:str>
  - name: expand
    description: The child resources to include in the response.
    defaultValue: None
    types:
    - <xref:str>
  keywordOnlyParameters:
  - name: cls
    description: A custom type or function that will be passed the direct response
    types:
    - <xref:callable>
  return:
    description: list of Advisor, or the result of cls(response)
    types:
    - <xref:list>[<xref:azure.mgmt.sql.models.Advisor>]
  exceptions:
  - type: azure.core.exceptions.HttpResponseError
- uid: azure.mgmt.sql.operations.DatabaseAdvisorsOperations.update
  name: update
  summary: Updates a database advisor.
  signature: 'update(resource_group_name: str, server_name: str, database_name: str,
    advisor_name: str, parameters: ''_models.Advisor'', **kwargs: Any) -> _models.Advisor'
  parameters:
  - name: resource_group_name
    description: 'The name of the resource group that contains the resource. You can

      obtain this value from the Azure Resource Manager API or the portal.'
    isRequired: true
    types:
    - <xref:str>
  - name: server_name
    description: The name of the server.
    isRequired: true
    types:
    - <xref:str>
  - name: database_name
    description: The name of the database.
    isRequired: true
    types:
    - <xref:str>
  - name: advisor_name
    description: The name of the Database Advisor.
    isRequired: true
    types:
    - <xref:str>
  - name: parameters
    description: The requested advisor resource state.
    isRequired: true
    types:
    - <xref:azure.mgmt.sql.models.Advisor>
  keywordOnlyParameters:
  - name: cls
    description: A custom type or function that will be passed the direct response
    types:
    - <xref:callable>
  return:
    description: Advisor, or the result of cls(response)
    types:
    - <xref:azure.mgmt.sql.models.Advisor>
  exceptions:
  - type: azure.core.exceptions.HttpResponseError
attributes:
- uid: azure.mgmt.sql.operations.DatabaseAdvisorsOperations.models
  name: models
  signature: models = <module 'azure.mgmt.sql.models' from 'C:\\hostedtoolcache\\windows\\Python\\3.11.9\\x64\\Lib\\site-packages\\azure\\mgmt\\sql\\models\\__init__.py'>