All Rules in Microsoft.SqlServer.Azure Management Pack

	DisplayName	Description	ID	Target	Category	Enabled	Instance Name	Counter Name	Frequency	Event_ID	Event Source	Alert Generate	Alert Severity	Alert Priority	Remotable	Event Log
	Azure SQL DB: DB Blocked by Firewall Count	This rule collects the count of connections blocked by the firewall in Microsoft Azure SQL Database. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseBlockedByFirewall	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Failed Connections Count	This rule collects the count of failed connections to Microsoft Azure SQL Database. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseConnectionFailed	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Successful Connections Count	This rule collects the count of successful connections to Microsoft Azure SQL Database. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseConnectionSuccessful	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB CPU Percentage	This rule collects the CPU resources of Microsoft Azure SQL Database 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseCpu	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Data IO Percentage	This rule collects the percentage of average data I/O utilization of service tier limit by Microsoft Azure SQL Database. 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseDataIO	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Deadlocks Count	This rule collects the count of deadlocks in Microsoft Azure SQL Database. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseDeadLock	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB DTU Used Count	This rule collects the number of DTUs allocated by Microsoft Azure SQL Database. Note that this rule doesn't work for Databases with the vCore-based pricing tier. 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseDtuAllocated	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB DTU Limit Count	This rule collects the number of DTUs Microsoft Azure SQL Database can allocate before reaching limit. Note that this rule doesn't work for Databases with the vCore-based pricing tier. 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseDtuFree	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB DTU Percentage	This rule collects the DTU resources of Microsoft Azure SQL Database 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseDtuPercent	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Free Space (MB)	This rule collects the amount of space left in Microsoft Azure SQL Database in megabytes. 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseFreeSpaceMb	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Free Space Percentage	This rule collects the amount of space left in Microsoft Azure SQL Database 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseFreeSpacePercent	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Transactions Locks Count	This rule collects transactions locks count for Microsoft Azure SQL Database. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseLocksCount	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Log IO Percentage	This rule collects the percentage of write resource utilization of the service tier limit by Microsoft Azure SQL Database. 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseLogWritePercent	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Sessions Count	This rule collects number of current Microsoft Azure SQL Database sessions. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseNumberOfSessions	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Total Space Quota (MB)	This rule collects the total available amount of space for Microsoft Azure SQL Database in megabytes. 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseQuotaSizeMb	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Sessions Average Memory Consumption (MB)	This rule collects average memory amount used by a single Microsoft Azure SQL Database session in megabytes. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseSessionsAverageMemoryMb	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Sessions Percentage	This rule collects the percentage of maximum concurrent sessions of the database’s service tier limit by Microsoft Azure SQL Database. 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseSessionsPercent	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Sessions Rows Returned	This rule collects number of rows returned by all current Microsoft Azure SQL Database sessions. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseSessionsRowsReturned	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Sessions Total CPU Time (ms)	This rule collects total CPU time used by all current Microsoft Azure SQL Database sessions. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseSessionsTotalCpu	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Sessions Total Read/Write Operations	This rule collects total read/write operations performed by requests in all current Microsoft Azure SQL Database sessions. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseSessionsTotalIo	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Sessions Total Memory Consumption (MB)	This rule collects total memory consumed by all Microsoft Azure SQL Database sessions in megabytes. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseSessionsTotalMemoryMb	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Transactions Max Log Usage (MB)	This rule collects max transactions log usage for Microsoft Azure SQL Database in megabytes. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseTransactionsMaxLogUsageMb	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Transactions Max Running Time (minutes)	This rule collects max transactions running time for Microsoft Azure SQL Database in minutes. Note that this rule works through T-SQL only. In order to prevent incorrect data collection, the value of Interval (seconds) overridable parameter should not be set lower than the default value.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseTransactionsMaxRunTimeMinutes	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Used Space (MB)	This rule collects the amount of space used by the Microsoft Azure SQL Database in megabytes. 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseUsedSpaceMb	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Used Space Percentage	This rule collects the amount of space used by Microsoft Azure SQL Database 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseUsedSpacePercent	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB Workers Percentage	This rule collects percentage of maximum concurrent workers (requests) of the database’s service tier limit by the Microsoft Azure SQL Database. 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseWorkerPercent	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: DB In-memory OLTP Storage Percentage	This rule collects the usage of In-memory OLTP Storage by Microsoft Azure SQL Database 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.	Microsoft.SqlServer.Azure.PerformanceRule.DatabaseXTPStoragePercent	Microsoft.SqlServer.Azure.UserDatabase	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Elastic Pool Data IO Percentage	This rule collects the data IO 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.	Microsoft.SqlServer.Azure.PerformanceRule.ElasticPool.AvgDataIoUtil	Microsoft.SqlServer.Azure.ElasticPool	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Elastic Pool Log IO Percentage	This rule collects the log write 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.	Microsoft.SqlServer.Azure.PerformanceRule.ElasticPool.AvgLogWriterUtil	Microsoft.SqlServer.Azure.ElasticPool	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Elastic Pool Sessions Percentage	This rule collects the sessions’ count of Microsoft Azure SQL Elastic Database Pool in percentage terms per limit. 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.	Microsoft.SqlServer.Azure.PerformanceRule.ElasticPool.MaxSessionUtil	Microsoft.SqlServer.Azure.ElasticPool	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Elastic Pool Storage Percentage	This rule collects the storage 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.	Microsoft.SqlServer.Azure.PerformanceRule.ElasticPool.MaxStorageUtil	Microsoft.SqlServer.Azure.ElasticPool	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Elastic Pool Workers Percentage	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.	Microsoft.SqlServer.Azure.PerformanceRule.ElasticPool.MaxWorkersUtil	Microsoft.SqlServer.Azure.ElasticPool	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Elastic Pool Databases Count	This rule collects the number of Microsoft Azure SQL Databases. 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.	Microsoft.SqlServer.Azure.PerformanceRule.ElasticPool.NumberOfDatabases	Microsoft.SqlServer.Azure.ElasticPool	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Elastic Pool CPU Percentage	This rule collects the CPU resources 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.	Microsoft.SqlServer.Azure.PerformanceRule.ElasticPoolCpu	Microsoft.SqlServer.Azure.ElasticPool	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Elastic Pool eDTU Used	This rule collects the eDTU resources of Microsoft Azure SQL Elastic Database Pool in unit 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.	Microsoft.SqlServer.Azure.PerformanceRule.ElasticPoolEDtuCount	Microsoft.SqlServer.Azure.ElasticPool	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Elastic Pool eDTU Percentage	This rule collects the eDTU resources 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.	Microsoft.SqlServer.Azure.PerformanceRule.ElasticPoolEDtuPercent	Microsoft.SqlServer.Azure.ElasticPool	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Server Databases Count	This rule collects the number of Microsoft Azure SQL Database hosted in Microsoft Azure SQL Database Cloud Service. 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.	Microsoft.SqlServer.Azure.PerformanceRule.NumberOfDatabases	Microsoft.SqlServer.Azure.Server	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Server DTU Used Count	This rule collects the number of DTUs allocated by Microsoft Azure SQL Database Cloud Service. 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.	Microsoft.SqlServer.Azure.PerformanceRule.Server.DtuAllocated	Microsoft.SqlServer.Azure.Server	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Server DTU Limit Count	This rule collects the number of DTUs Microsoft Azure SQL Database Cloud Service can allocate before reaching limit. 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.	Microsoft.SqlServer.Azure.PerformanceRule.Server.DtuFree	Microsoft.SqlServer.Azure.Server	PerformanceCollection	True			0	0		False			True
	Azure SQL DB: Server DTU Percentage	This rule collects DTUs allocated by Microsoft Azure SQL Database Cloud Service 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.	Microsoft.SqlServer.Azure.PerformanceRule.Server.DtuPercent	Microsoft.SqlServer.Azure.Server	PerformanceCollection	True			0	0		False			True
	Microsoft Azure SQL Database .Net Framework Rule	This rule provides Microsoft Azure SQL Database Management Pack workflows .Net Framework version check. 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.	Microsoft.SqlServer.Azure.Rule.CheckDotNetVersion	Microsoft.SqlServer.Azure.EventLogCollectionTarget	Alert	True			0	0		True	Error	High	True
	Microsoft Azure SQL Database Management Pack Self-Monitoring	This rule provides Microsoft Azure SQL Database Management Pack workflows self-monitoring for critical issues.	Microsoft.SqlServer.Azure.Rule.SelfMonitoringCritical	Microsoft.SqlServer.Azure.EventLogCollectionTarget	Alert	True			0	0		True	Error	High	True	Operations Manager
	Microsoft Azure SQL Database Management Pack Self-Monitoring (Non-Critical)	This rule provides Microsoft Azure SQL Database Management Pack workflows self-monitoring for non-critical issues.	Microsoft.SqlServer.Azure.Rule.SelfMonitoringWarning	Microsoft.SqlServer.Azure.EventLogCollectionTarget	Alert	True			0	0		True	Warning	Normal	True	Operations Manager