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

Question

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?

Answer 1

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.

Regards,
Oury

Answer 2

Please share an update on this.

Answer 3

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.