none
Error executing SELECT from sys.elastic_pool_resource_stats

    Question

  • The following has been observed in a development elastic pool for more than 24 hrs. 

    When executing the following via SSMS attached to my Azure server,

    SELECT start_time, end_time,     
      (SELECT Max(v)     
    FROM (VALUES (avg_cpu_percent), (avg_data_io_percent), (avg_log_write_percent)) AS value(v)) AS [avg_DTU_percent]   
    FROM sys.elastic_pool_resource_stats  

    I receive the following error:

    Msg 40197, Level 20, State 2, Line 1
    The service has encountered an error processing your request. Please try again. Error code 9100.

    At https://docs.microsoft.com/en-us/azure/sql-database/sql-database-develop-error-messages (for 40197)

    I read "You receive this error when the service is down due to software or hardware upgrades, hardware failures, or any other failover problems. The error code (%d) embedded within the message of error 40197 provides additional information about the kind of failure or failover that occurred. Some examples of the error codes are embedded within the message of error 40197 are 40020, 40143, 40166, and 40540."

    I cannot find any information on the 9100 error code.  Any suggestions would be appreciated.  In the absence of anything else I can always open low-level case.

    Wednesday, January 03, 2018 3:57 PM

All replies