Azure SQL DB: Elastic Pool Workers Percentage

Microsoft.SqlServer.Azure.PerformanceRule.ElasticPool.MaxWorkersUtil (Rule)

This rule collects the workers utilization of Microsoft Azure SQL Elastic Database Pool in percentage terms.
Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.

Knowledge Base article:

Summary

This rule collects the workers utilization of Microsoft Azure SQL Elastic Database Pool in percentage terms.

Note that in order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.

Overrideable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	Yes
Interval (seconds)	The recurring interval of time in seconds in which to run the workflow. Note that interval value should be divisible by 300.	900
Monitoring Mode	Defines monitoring mode.	$Target/Host/Property[Type="Microsoft.SqlServer.Azure.Server"]/MonitoringMode$
Request timeout (seconds)	Gets or sets the timespan to wait before the request times out.	60
Synchronization Time	The synchronization time specified by using a 24-hour format. May be omitted.
Timeout (seconds)	Specifies the time the workflow is allowed to run before being closed and marked as failed.	600
Timeout for database connection (seconds)	A period in which the workflow must establish connection to the database.	30

Element properties:

Target	Microsoft.SqlServer.Azure.ElasticPool
Category	PerformanceCollection
Enabled	True
Alert Generate	False
Remotable	True

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SqlServer.Azure.Module.ElasticPoolResourceStatsMonitoringDataSource	Default
Mapper	ConditionDetection	Microsoft.SqlServer.Azure.Module.PropertyBagCookdownPerformanceDataMapper	Default
WriteToDB	WriteAction	Microsoft.SystemCenter.CollectPerformanceData	Default
WriteToDW	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData	Default

Source Code:

<Rule ID="Microsoft.SqlServer.Azure.PerformanceRule.ElasticPool.MaxWorkersUtil" Target="Microsoft.SqlServer.Azure.ElasticPool" Enabled="true" ConfirmDelivery="false">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Microsoft.SqlServer.Azure.Module.ElasticPoolResourceStatsMonitoringDataSource">

      <IntervalSeconds>900</IntervalSeconds>

      <SyncTime/>

      <TimeoutSeconds>600</TimeoutSeconds>

      <ServerName>$Target/Host/Property[Type="Microsoft.SqlServer.Azure.Server"]/ServerName$</ServerName>

      <ElasticPoolName>$Target/Property[Type="Microsoft.SqlServer.Azure.ElasticPool"]/ElasticPoolName$</ElasticPoolName>

      <UseRest>$Target/Host/Property[Type="Microsoft.SqlServer.Azure.Server"]/UseREST$</UseRest>

      <MonitoringMode>$Target/Host/Property[Type="Microsoft.SqlServer.Azure.Server"]/MonitoringMode$</MonitoringMode>

      <AuthorityDetails>$Target/Host/Property[Type="Microsoft.SqlServer.Azure.Server"]/AuthorityDetails$</AuthorityDetails>

      <SubscriptionId>$Target/Host/Property[Type="Microsoft.SqlServer.Azure.Server"]/Subscription$</SubscriptionId>

      <ResourceGroupName>$Target/Host/Property[Type="Microsoft.SqlServer.Azure.Server"]/ResourceGroupName$</ResourceGroupName>

      <SqlTimeoutSeconds>30</SqlTimeoutSeconds>

      <HttpTimeoutSeconds>60</HttpTimeoutSeconds>

    </DataSource>

  </DataSources>

  <ConditionDetection ID="Mapper" TypeID="Microsoft.SqlServer.Azure.Module.PropertyBagCookdownPerformanceDataMapper">

    <ObjectName>SQL Azure Elastic Pool</ObjectName>

    <CounterName>Workers Percentage</CounterName>

    <InstanceName/>

    <ResourceName>$Target/Property[Type="Microsoft.SqlServer.Azure.ElasticPool"]/ElasticPoolName$</ResourceName>

    <MetricName>workers_percent</MetricName>

  </ConditionDetection>

  <WriteActions>

    <WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>

    <WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>

  </WriteActions>

</Rule>