Azure Monitor: Query failed to execute because hinting request has failed

Grafana Azure Monitor
1

  • What Grafana version and what operating system are you using?
    Grafana v10.0.0 (81d85ce802)
    Windows 10

  • What are you trying to achieve?
    Trying to visualize metrics of the SQL databases.

  • How are you trying to achieve it?
    Added Azure Monitor plugin and selected all the SQL databases from a resource group.

  • What happened?
    The query failed with the errorMessage:"Query failed to execute because hinting request has failed.

  • What did you expect to happen?
    Visualize the metric on the dashboard

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    errorMessage:"Query failed to execute because hinting request has failed. Requested Metric:MicrosoftSqlShoeboxsouthcentralus|MicrosoftSql|cpu_percent. Output Dimensions: microsoft.resourceid. Dimension Filters: microsoft.resourceGroupName,microsoft.resourceId,microsoft.resourceType,microsoft.subscriptionId,ResourceId. RequestedSamplingType: Sum. Start time: 11/20/2023 6:28:03 PM End time: 12/20/2023 6:27:03 PM. Resolution: 00:30:00, Last Value Mode: False. Context:MetricsMP, CustomerId:Unknown. TraceID:{aaa-bbbb-bbb-bbb};AzSubId=999-999-999-99;AzResType=microsoft.sql/servers/databases;AzRegion=southcentralus;, IsUserQuery:1, ClientTimeout:00:01:40, ClientName:GatewayService-API->QueryServiceCoordinator, ElapsedTime(ms):18, Exception:System.ServiceModel.FaultException`1[Microsoft.Online.Hinting.Contracts.HintsRetrievalFault]: Number of filter values for dimension exceeds max allowed value.Dimension:microsoft.resourceid,Filter count:5102,Max allowed value:4000 (Fault Detail is equal to Microsoft.Online.Hinting.Contracts.HintsRetrievalFault)…

  • Did you follow any online instructions? If so, what is the URL?

Is there any config to increase the max allowed value above 4000?

2

That looks like Azure limit, so try to ask your Azure support.

1 Like