UIM probe Azure metric question

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Customer wanted Clarity on the AZURE METRIC:

Workers Percentage
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.

 

Environment

Release : 20.1

 

Cause

 Documentation did not have clear enough information on what it was and how he could use this to setup effective threshold for alarming.

Resolution

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

https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-resource-management

Example of how it works:"

Below 80%. Spikes up to 100% will cause connection attempts and queries to fail.