The Zabbix Agent service runs as a local Windows user (typically SYSTEM ). This account often does not have permissions to read SQL performance counters or query the SQL instance.
Switch to sys.dm_db_resource_stats or sys.server_resource_stats views. Customize the user parameter to query these instead. The official Zabbix template for Azure SQL Database is different from on-prem MSSQL. zabbix mssql failed to fetch info data -or no data for 30m-
MSSQL: Failed to fetch info data (or no data for 30m) - Zabbix The Zabbix Agent service runs as a local