Skip to content

Azure SQL Servers

Collect Azure SQL Servers Metrics.

Configuration

Install Func

It is recommended to activate the TrueWatch Integration - Extensions - DataFlux Func (Automata): All prerequisites are automatically installed. Please proceed with the script installation.

If you deploy Func yourself, refer to Self-deployed Func

It is recommended to deploy the GSE version.

Install Script

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

To synchronize monitoring data for Azure-SQL Server, we install the corresponding collection script: "TrueWatch Integration (Azure-SQL Server Database Collection)" (ID: integration_azure_sql_server_database).

After clicking [Install], input the corresponding parameters:

  • Azure Tenant ID: Tenant ID
  • Azure Client ID: Application Registration Client ID
  • Azure Client Secret Value: Client Secret Value, note that it is not the ID
  • Subscriptions: Subscription ID, multiple subscriptions separated by ,

Click [Deploy Startup Script], the system will automatically create the Startup script set and configure the corresponding startup scripts.

After enabling, you can see the corresponding automatic trigger configuration in "Manage / Automatic Trigger Configuration". Click [Execute] to immediately execute once without waiting for the scheduled time. Wait a moment to view the execution task records and corresponding logs.

Verification

  1. In "Manage / Automatic Trigger Configuration", confirm whether the corresponding task has the corresponding automatic trigger configuration, and check the task records and logs for any exceptions.
  2. In TrueWatch, check if asset information exists in "Infrastructure / Custom".
  3. In TrueWatch, check if there are corresponding monitoring data in "Metrics".

Metrics

After configuring Azure SQL Servers monitoring data, the default Measurement is as follows. More Metrics can be collected through configuration Microsoft.Sql/servers/databases Supported Metrics

Metric Name Description Unit
allocated_data_storage_average Allocated Data Space byte
app_cpu_billed_total Billed App CPU count
app_cpu_percent_average App CPU Usage %
app_memory_percent_average App Memory Usage Percentage %
availability_average Availability Average count
blocked_by_firewall_total Total Blocked by Firewall count
connection_failed_user_error_total Total Connection Failures Due to User Error count
connection_successful_total Total Successful Connections count
cpu_limit_average CPU Limit Average count
cpu_percent_average CPU Usage Percentage Average %
cpu_used_average CPU Usage Average count
deadlock_total Total Deadlocks count
diff_backup_size_bytes_maximum Differential Backup Size Bytes Maximum byte
full_backup_size_bytes_maximum Full Backup Size Bytes Maximum byte
log_backup_size_bytes_maximum Log Backup Size Bytes Maximum byte
log_write_percent_average Log Write Percentage Average %
physical_data_read_percent_average Physical Data Read Percentage Average %
sessions_count_average Sessions Count Average count
sessions_percent_average Sessions Percentage Average %
sql_instance_cpu_percent_maximum SQL Instance CPU Percentage Maximum %
sql_instance_memory_percent_maximum SQL Instance Memory Percentage Maximum %
storage_maximum Used Data Space byte
storage_percent_maximum Used Data Space Percentage %
workers_percent_average Workers Percentage Average %
xtp_storage_percent_average XTP Storage Percentage Average %