Unable to fetch query statistics using 'LIST API by MANAGED INSTANCE'' from Azure SQL Managed Instance

Appmanager Zohocorp 41 Reputation points
2022-04-29T14:56:12.023+00:00

We are using Azure SQL Managed Instance when I tried to get instance's top resource consuming queries by using the rest api, I get an internal server error.

{
"error": {
"code": "InternalServerError",
"message": "An unexpected error occured while processing the request. Tracking ID: '3526e241-2175-4888-8f75-7606a2103e6c'"
}
}

But I can able to see the data available in SQL Server Management Studio under My Database -> Query store -> Top Resource Consuming Queries.

Is there any pre-requisites need to be done to get in rest API or how can I resolve it?

Azure SQL Database
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
    2022-04-29T21:48:49.383+00:00

    Hi @Appmanager Zohocorp Thank you for posting your query on Microsoft Q&A and for using Azure services.

    My understanding is that you are facing an internal server error while fetching statistics using List API by managed Instance from an Azure SQL Managed Instance.

    I tried to repo the issue from my end and successfully retrieve the managed Instance keys

    Please check if you have used the correct parameters below

    197893-image.png

    I tested this directly from the doc you shared above.

    197903-image.png

    Regards,
    Oury

  2. Appmanager Zohocorp 41 Reputation points
    2022-05-09T14:26:14.633+00:00

    Please share an update on this.

  3. Appmanager Zohocorp 41 Reputation points
    2022-05-17T06:00:13.773+00:00

    Hi,

    Thank you for the information provided.

    Can you please notify us, when the required configuration done for the API and rolled out world-wide ?

    Please share us the list of regions which is supported for the API as of now.