Monitoring Azure SQL Server Service
The Azure SQL Server Service sensor is automatically deployed and installed after you install the Instana agent.
Note: Learn about the other supported Azure services with our Azure documentation.
Azure SQL Server sensor can be disabled and it can be filtered by tags and resource groups. It is possible to configure Azure SQL Server sensor via agent configuration in
com.instana.plugin.azure.sqlserver: # Valid values: true, false enabled: false # enabled (true) by default # Comma separated list of tags in key:value format include_tags: # Comma separated list of tags in key:value format exclude_tags: # Comma separated list of resource groups include_resource_groups: # Comma separated list of resource groups exclude_resource_groups:
Azure SQL Server sensor can be disabled. To disable monitoring of the Azure SQL Server services use the following configuration:
com.instana.plugin.azure.sqlserver: enabled: false
Multiple tags and resource groups can be defined, separated by a comma. Tags should be provided as a key-value pair separated by
:. In order to make configuration easier, it is possible to define which tags and resource groups you
want to include in discovery or exclude from discovery. In case of defining tag or resource group in both lists (include and exclude), exclude list has higher priority. If there is no need for services filtering, the configuration should not
be defined. It's not mandatory to define all values in order to enable filtering.
To include services by tags into discovery use following configuration:
com.instana.plugin.azure.sqlserver: include_tags: # Comma separated list of tags in key:value format (e.g. env:prod,env:staging)
To exclude services by tags from discovery use following configuration:
com.instana.plugin.azure.sqlserver: exclude_tags: # Comma separated list of tags in key:value format (e.g. env:dev,env:test)
To include services by resource groups into discovery use following configuration:
com.instana.plugin.azure.sqlserver: include_resource_groups: # Comma separated list of resource groups (e.g. rg_prod,rg_staging)
To exclude services by resource groups from discovery use following configuration:
com.instana.plugin.azure.sqlserver: exclude_resource_groups: # Comma separated list of resource groups (e.g. rg_dev,rg_test)
Discovery filtering can be configured on the global level for all Azure services. In case of defining filters for Azure SQL Server service, global filters will be overridden. For more details about global Azure service discovery filtering visit Azure Configuration.
To view the metrics, select Infrastructure in the sidebar of the Instana User interface, click a specific monitored host, and then you can see a host dashboard with all the collected metrics and monitored processes.
Available databases and elastic pools are pulled every 10 minutes.
|Resource Group||The resource group of the SQL server|
|Subscription Id||The subscription ID of the SQL server|
|FQDN||The fully qualified domain name of the server|
|State||The state of the server|
|Version||The version of the server.|
|Max Size||The max size of the database expressed in bytes|
|Status||The status of the database|
|SKU||Pricing tier (SKU)|
|Elastic Pool Details||Description|
|Name||Elastic pool name|
|Location||Elastic pool location|
|Max Size||The storage limit for the elastic pool in bytes.|
|State||The state of the elastic pool (Creating, Disabled, Ready)|
|SKU||Pricing tier (SKU)|