Customer wanted Clarity on the AZURE METRIC:
QoS Name: QOS_AZURE_SQL_ELASTIC_POOL_WORKERS_PERCENTAGE
Technical document Description: This metric is the percentage of available workers used by the SQL elastic pool.
Release : 20.1
Documentation did not have clear enough information on what it was and how he could use this to setup effective threshold for alarming.
Information from the Microsoft site on the Azure metric States:
The Worker thread utilization is provided for each database in the pool, as well as for the pool itself.
There are different limits on the number of worker thread level. and at the pool level.
It is recommended that that it is monitored at both levels.
Can be found in the sys.dm db resource stats view in every database and in the sys.elastic pool resource stats view in the master database.
Can be viewed in Azure porta and is named workers_percent
Example of how it works:"
Below 80%. Spikes up to 100% will cause connection attempts and queries to fail.