topic Re: Dashboard Metric Explorer in Dashboarding

Dashboard Metric Explorer

DBAJames — Fri, 20 Dec 2024 14:36:17 GMT

I can not longer add SQL metrics to my dashboard. Despite giving me the metric or using one in user on another dashboard it says doesnt exist:

"errorType": "FIELD_DOES_NOT_EXIST",
"errorMessage": "The field `avg(sql-server.buffers.cacheHitRatio)` doesn't exist.",

Re: Dashboard Metric Explorer

AntonPineiro — Fri, 20 Dec 2024 15:02:17 GMT

Hi,

Can you show a Data Explorer screenshot?

Best regards

Re: Dashboard Metric Explorer

DBAJames — Fri, 20 Dec 2024 15:10:01 GMT

what information do you require, just the list of SQL

Re: Dashboard Metric Explorer

DBAJames — Fri, 20 Dec 2024 15:39:10 GMT

Explore Metrics produces this (not working):
timeseries avg(`sql-server.general.userConnections`), by: { `dt.entity.sql:sql_server_instance` }
| fieldsAdd value.A = arrayAvg(`avg(sql-server.general.userConnections)`)
| limit 20

Re: Dashboard Metric Explorer

DBAJames — Fri, 20 Dec 2024 15:40:22 GMT

SQL Server overview uses(working):
timeseries
connections = avg(`sql-server.general.userConnections`),
by: {`dt.entity.sql:sql_server_instance`}
| sort arrayAvg(connections) desc
| fieldsAdd entityName(`dt.entity.sql:sql_server_instance`)
| limit 20

Re: Dashboard Metric Explorer

AntonPineiro — Sun, 22 Dec 2024 11:42:25 GMT

Hi,

Just one metric coming by extension. My point is if you are getting datapoints for some metric by extension.

Best regards

Re: Dashboard Metric Explorer

sia_h — Tue, 24 Dec 2024 12:21:20 GMT

Please raise a support ticket. I’ve encountered similar issues and managed to find a workaround by accessing the classic data explorer, querying the metric, and then opening it in DQL.