The User - Response Time alarm is raised when the time taken for Spotlight to send a simple query to the monitored Azure SQL Managed instance, have it processed and get the answer back is more than 20 seconds (or the configured threshold). The Response Time alarm does not tell you where the time is spent; it could be the network or it could be the Azure SQL Managed instance is unresponsive.
This is not an error. Spotlight is just saying that it is taking over 20 seconds (or the configured threshold) to run the response time query in your environment. This could be indicative of:
- Response time SQL blocking (Check the configured Response Time SQL)
- A network issue between the Spotlight Diagnostic Server and the monitored Azure SQL Managed Instance(s)
- A problem with the monitored Azure SQL Managed Instance(s)
You may want to find out what the Response Time SQL is (default “select 1”) and run that SQL from SQL Server Management Studio from the Spotlight Diagnostic Server host against one of the monitored SQL Servers exhibiting the issue.
In the Spotlight Client, members of the Spotlight diagnostic administrators group can change the SQL Statement used to measure Azure SQL Managed Instance response time.