Skip to content

Azure SQL Servers

Collect Azure SQL Servers Metrics.

Configuration

Install Func

It is recommended to enable TrueWatch integration - extension - DataFlux Func (Automata): all prerequisites are automatically installed, please proceed with the script installation.

If deploying Func manually, refer to Manual Func Deployment

Recommended to deploy 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 it is not the ID
  • Subscriptions: Subscription ID, multiple subscriptions separated by ,

Click [Deploy Startup Script], the system will automatically create Startup script sets 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. After a while, you can check 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 corresponding 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 %
active_queries_total Number of active queries across all workload groups; applies to data warehouse only. count
app_cpu_billed_ha_replicas_total Total billable application CPU usage for all high-availability replicas associated with the primary or named replica. count
base_blob_size_bytes_maximum Storage space occupied by data; applicable to Hyperscale database. B
cache_hit_percent_maximum Cache hit percentage; applies to data warehouse only. %
cache_used_percent_maximum Cache usage percentage; applies to data warehouse only. %
connection_failed_total The number of connection failures due to system errors. count
dtu_consumption_percent_average DTU usage percentage; applies to databases based on DTU. %
dtu_limit_average DTU upper limit; applies to databases based on DTU. count
dtu_used_average Number of DTU used; for databases based on DTU. count
dwu_consumption_percent_maximum DWU Use percentage; applies to data warehouse only. %
dwu_limit_maximum DWU cap; applies to data warehouse only. count
dwu_used_maximum Amount of DWU used; applies to data warehouse only. count
free_amount_consumed_average Free vCore seconds used this month; applies to free database products only. count
free_amount_remaining_average vCore free seconds remaining for the month; applies to free database products only. count
ledger_digest_upload_failed_count The number of failed attempts to upload the ledger summary. count
ledger_digest_upload_success_count The number of successful uploads of the ledger summary. count
local_tempdb_usage_percent_average Local tempdb usage percentage; applies to data warehouse only. %
memory_usage_percent_maximum Memory usage percentage; applies to data warehouse only. %
queued_queries_total Number of queued queries across all workload groups; applies to data warehouse only. count
replication_lag_seconds_average The number of seconds the secondary database is behind the primary database, also known as RPO; available on the primary database only and in preview. s
snapshot_backup_size_bytes_maximum Cumulative data backup storage size; applicable to Hyperscale database. B
sqlserver_process_core_percent_maximum CPU usage percentage of the SQL DB process; does not apply to data warehouses. Equivalent to sql_instance_cpu_percent, the official plan is to remove it in the future. %
tempdb_data_size_maximum tempdb Data file used space, measured in KB; not applicable to data warehouse. KB
tempdb_log_size_maximum tempdb Transaction log file used space, in KB; does not apply to data warehouses. KB
tempdb_log_used_percent_maximum tempdb Percentage of space used by transaction log files; does not apply to data warehouses. %
wlg_active_queries_total Number of active queries in the workload group; applies to data warehouse only. count
wlg_active_queries_timeouts_total Number of queries in the workload group that have timed out; applies to data warehouse only. count
wlg_allocation_relative_to_system_percent_maximum The resources allocated to the workload group as a percentage of the overall system resources; applies to data warehouse only. %
wlg_allocation_relative_to_wlg_effective_cap_percent_maximum The resources assigned to the workload group as a percentage of the group's resource limit; applies to data warehouses only. %
wlg_effective_cap_resource_percent_maximum A hard cap on the percentage of resources available for this group after taking into account the effective minimum resource reservations of other workload groups; applies to data warehouses only. %
wlg_effective_min_resource_percent_maximum The minimum percentage of resources reserved and isolated for a workload group after taking into account service level minimums; applies to data warehouses only. %
wlg_queued_queries_total Number of queued queries in the workload group; applies to data warehouse only. count