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

  • 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?

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

1 Like