Azure SQL Servers¶

Collect metrics data from Azure SQL Servers.

Configuration¶

Install Func¶

It is recommended to enable Guance integration - extension - managed Func: all prerequisites are automatically installed, please continue with the script installation

If you deploy Func manually, refer to Manual Deployment of Func

It is recommended to deploy the GSE version

Installation Script¶

Note: Please prepare the required Azure application registration information in advance and assign the Monitoring Reader role to the application registration

To synchronize Azure-SQL Server monitoring data, we install the corresponding collection script: 「Guance Integration (Azure-SQL Server Database Collection)」(ID: guance_azure_sql_server_database)

After clicking 【Install】, enter the corresponding parameters:

• Azure Tenant ID: Tenant ID
• Azure Client ID: Application Registration Client ID
• Azure Client Secret Value: Client password value, note it's not the ID
• Subscriptions: Subscription ID, multiple subscriptions are separated by ,

Click 【Deploy Startup Script】, and the system will automatically create a Startup script set and automatically configure the corresponding startup script.

After enabling, you can see the corresponding automatic trigger configuration in 「Manage / Automatic Trigger Configuration」. Click 【Execute】to immediately run once without waiting for the scheduled time. After a short wait, you can view the execution task records and corresponding logs.

We collect some configurations by default; for details, see the metrics section.

Configure Custom Cloud Object Metrics

Verification¶

1. In 「Manage / Automatic Trigger Configuration」, confirm whether the corresponding task has an automatic trigger configuration, and at the same time, check the corresponding task records and logs for any abnormalities.
2. In Guance, under 「Infrastructure / Custom」, check if there is asset information.
3. In Guance, under 「Metrics」, check if there are corresponding monitoring data.

Metrics¶

After configuring Azure Sql Servers monitoring data, the default metric set is as follows. You can collect more metrics through configuration Microsoft.Sql/servers/databases Supported Metrics