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 Readerrole 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 IDAzure Client ID: Application registration Client IDAzure Client Secret Value: Client secret value, note it is not the IDSubscriptions: 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¶
- 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.
- In TrueWatch, check if asset information exists in "Infrastructure / Custom".
- 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 |