Azure Microsoft SQL Serverless Database by HTTP Template Script Update
Recently I needed to implement the
template Template Azure Microsoft SQL Serverless Database via HTTP on a resource in Azure but I came across the Java Script error reporting an incorrect request error and that the metrics were not valid so in a brief search I came across this block of the script that when update the item that collects the mass data and update the variables where the metrics that will be collected are declared and put this in place:
---
var metrics = [
'cpu_percent',
'physical_data_read_percent',
'log_write_percent',
'dtu_consumption_percent',
'storage',
'connection_successful',
'connection_failed',
'connection_failed_user_error',
'blocked_by_firewall',
'deadlock',
'storage_percent',
'xtp_storage_percent',
'workers_percent',
'sessions_percent',
'sessions_count',
'dtu_limit',
'dtu_used',
'sqlserver_process_core_percent',
'sqlserver_process_memory_percent',
'sql_instance_cpu_percent',
'sql_instance_memory_percent',
'tempdb_data_size',
'tempdb_log_size',
'tempdb_log_used_percent',
'allocated_data_storage',
'ledger_digest_upload_success',
'ledger_digest_upload_failed'
];
----
Just update the template script and follow the macro settings and your metrics will likely be collected.
template Template Azure Microsoft SQL Serverless Database via HTTP on a resource in Azure but I came across the Java Script error reporting an incorrect request error and that the metrics were not valid so in a brief search I came across this block of the script that when update the item that collects the mass data and update the variables where the metrics that will be collected are declared and put this in place:
---
var metrics = [
'cpu_percent',
'physical_data_read_percent',
'log_write_percent',
'dtu_consumption_percent',
'storage',
'connection_successful',
'connection_failed',
'connection_failed_user_error',
'blocked_by_firewall',
'deadlock',
'storage_percent',
'xtp_storage_percent',
'workers_percent',
'sessions_percent',
'sessions_count',
'dtu_limit',
'dtu_used',
'sqlserver_process_core_percent',
'sqlserver_process_memory_percent',
'sql_instance_cpu_percent',
'sql_instance_memory_percent',
'tempdb_data_size',
'tempdb_log_size',
'tempdb_log_used_percent',
'allocated_data_storage',
'ledger_digest_upload_success',
'ledger_digest_upload_failed'
];
----
Just update the template script and follow the macro settings and your metrics will likely be collected.
Comment