Azure SQL Server

kubernetes opsverse's kubernetes agent https //docs opsverse io/install the opsverse agent#veqxm can collect metrics from azure sql server add the following yaml snippet to the agent's values yaml and run the agent based on these instructions https //docs opsverse io/install the opsverse agent#veqxm the placeholders \<azure client id>, \<azure tenant id>, \<azure client secret>, \<resource subscription id> in the following yaml with the appropriate details azure metrics exporter enabled true env debug "true" verbose "true" azure client id "\<azure client id>" azure tenant id "\<azure tenant id>" azure client secret "\<azure client secret>" victoria metrics agent extrascrapeconfigs \ job name az sql metrics scrape interval 30s metrics path /probe/metrics/list params name \ az sql template \ '{name} {metric}' subscription \ \<resource subscription id> resourcetype \ microsoft sql/servers/databases metric \ app cpu billed \ app cpu percent \ app memory percent \ availability \ blocked by firewall \ cpu percent \ cpu limit \ cpu used \ physical data read percent \ allocated data storage \ storage \ storage percent \ deadlock \ connection failed \ connection failed user error \ ledger digest upload failed \ xtp storage percent \ log write percent \ sessions count \ sessions percent \ connection successful \ ledger digest upload success \ workers percent \ sql instance cpu percent \ sql instance memory percent \ sqlserver process core percent \ sqlserver process memory percent \ tempdb data size \ tempdb log size \ tempdb log used percent \ diff backup size bytes \ full backup size bytes \ log backup size bytes static configs \ targets \ http //devopsnow agent azure metr devopsnow\ svc cluster local 8080