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

Appmanager Zohocorp 21 Reputation points

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 No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Oury Ba-MSFT 11,371 Reputation points Microsoft Employee

    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


    I tested this directly from the doc you shared above.



  2. Appmanager Zohocorp 21 Reputation points

    Please share an update on this.

  3. Appmanager Zohocorp 21 Reputation points


    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.