| 1 | # you can disable an alarm notification by setting the 'to' line to: silent |
| 2 | |
| 3 | # --- CPU Utilization --- |
| 4 | |
| 5 | template: am_sql_elastic_pool_cpu |
| 6 | on: azure_monitor.sql_elastic_pool.cpu |
| 7 | class: Utilization |
| 8 | type: Database |
| 9 | component: Azure SQL Elastic Pool |
| 10 | lookup: average -5m unaligned of average |
| 11 | units: percentage |
| 12 | every: 1m |
| 13 | warn: $this > (($status >= $WARNING) ? (75) : (85)) |
| 14 | crit: $this > (($status == $CRITICAL) ? (85) : (95)) |
| 15 | delay: down 5m multiplier 1.5 max 1h |
| 16 | summary: SQL Elastic Pool CPU on ${label:resource_name} |
| 17 | info: Average CPU utilization of SQL Elastic Pool ${label:resource_name} \ |
| 18 | in ${label:resource_group} (${label:region}) |
| 19 | to: dba |
| 20 | |
| 21 | template: am_sql_elastic_pool_instance_cpu |
| 22 | on: azure_monitor.sql_elastic_pool.instance_cpu |
| 23 | class: Utilization |
| 24 | type: Database |
| 25 | component: Azure SQL Elastic Pool |
| 26 | lookup: average -5m unaligned of average |
| 27 | units: percentage |
| 28 | every: 1m |
| 29 | warn: $this > (($status >= $WARNING) ? (75) : (85)) |
| 30 | crit: $this > (($status == $CRITICAL) ? (85) : (95)) |
| 31 | delay: down 5m multiplier 1.5 max 1h |
| 32 | summary: SQL Elastic Pool instance CPU on ${label:resource_name} |
| 33 | info: SQL instance CPU utilization of SQL Elastic Pool ${label:resource_name} \ |
| 34 | in ${label:resource_group} (${label:region}). \ |
| 35 | Includes overhead beyond user workloads |
| 36 | to: dba |
| 37 | |
| 38 | # --- Memory Utilization --- |
| 39 | |
| 40 | template: am_sql_elastic_pool_instance_memory |
| 41 | on: azure_monitor.sql_elastic_pool.instance_memory |
| 42 | class: Utilization |
| 43 | type: Database |
| 44 | component: Azure SQL Elastic Pool |
| 45 | lookup: average -5m unaligned of average |
| 46 | units: percentage |
| 47 | every: 1m |
| 48 | warn: $this > (($status >= $WARNING) ? (80) : (90)) |
| 49 | crit: $this > (($status == $CRITICAL) ? (90) : (95)) |
| 50 | delay: down 5m multiplier 1.5 max 1h |
| 51 | summary: SQL Elastic Pool instance memory on ${label:resource_name} |
| 52 | info: SQL instance memory utilization of SQL Elastic Pool ${label:resource_name} \ |
| 53 | in ${label:resource_group} (${label:region}) |
| 54 | to: dba |
| 55 | |
| 56 | # --- DTU Utilization --- |
| 57 | |
| 58 | template: am_sql_elastic_pool_dtu_consumption |
| 59 | on: azure_monitor.sql_elastic_pool.dtu_consumption |
| 60 | class: Utilization |
| 61 | type: Database |
| 62 | component: Azure SQL Elastic Pool |
| 63 | lookup: average -5m unaligned of average |
| 64 | units: percentage |
| 65 | every: 1m |
| 66 | warn: $this > (($status >= $WARNING) ? (75) : (85)) |
| 67 | crit: $this > (($status == $CRITICAL) ? (85) : (95)) |
| 68 | delay: down 5m multiplier 1.5 max 1h |
| 69 | summary: SQL Elastic Pool DTU consumption on ${label:resource_name} |
| 70 | info: DTU consumption percentage of SQL Elastic Pool ${label:resource_name} \ |
| 71 | in ${label:resource_group} (${label:region}). \ |
| 72 | High DTU usage indicates approaching the pool performance limit |
| 73 | to: dba |
| 74 | |
| 75 | # --- I/O Utilization --- |
| 76 | |
| 77 | template: am_sql_elastic_pool_data_io |
| 78 | on: azure_monitor.sql_elastic_pool.io_utilization |
| 79 | class: Utilization |
| 80 | type: Database |
| 81 | component: Azure SQL Elastic Pool |
| 82 | lookup: average -5m unaligned of data_read |
| 83 | units: percentage |
| 84 | every: 1m |
| 85 | warn: $this > (($status >= $WARNING) ? (80) : (90)) |
| 86 | crit: $this > (($status == $CRITICAL) ? (90) : (95)) |
| 87 | delay: down 5m multiplier 1.5 max 1h |
| 88 | summary: SQL Elastic Pool data I/O on ${label:resource_name} |
| 89 | info: Physical data read I/O utilization of SQL Elastic Pool ${label:resource_name} \ |
| 90 | in ${label:resource_group} (${label:region}) |
| 91 | to: dba |
| 92 | |
| 93 | template: am_sql_elastic_pool_log_write |
| 94 | on: azure_monitor.sql_elastic_pool.io_utilization |
| 95 | class: Utilization |
| 96 | type: Database |
| 97 | component: Azure SQL Elastic Pool |
| 98 | lookup: average -5m unaligned of log_write |
| 99 | units: percentage |
| 100 | every: 1m |
| 101 | warn: $this > (($status >= $WARNING) ? (80) : (90)) |
| 102 | crit: $this > (($status == $CRITICAL) ? (90) : (95)) |
| 103 | delay: down 5m multiplier 1.5 max 1h |
| 104 | summary: SQL Elastic Pool log write on ${label:resource_name} |
| 105 | info: Transaction log write utilization of SQL Elastic Pool ${label:resource_name} \ |
| 106 | in ${label:resource_group} (${label:region}) |
| 107 | to: dba |
| 108 | |
| 109 | # --- Resource Limits --- |
| 110 | |
| 111 | template: am_sql_elastic_pool_workers |
| 112 | on: azure_monitor.sql_elastic_pool.resource_utilization |
| 113 | class: Utilization |
| 114 | type: Database |
| 115 | component: Azure SQL Elastic Pool |
| 116 | lookup: average -5m unaligned of workers |
| 117 | units: percentage |
| 118 | every: 1m |
| 119 | warn: $this > (($status >= $WARNING) ? (70) : (80)) |
| 120 | crit: $this > (($status == $CRITICAL) ? (80) : (90)) |
| 121 | delay: down 5m multiplier 1.5 max 1h |
| 122 | summary: SQL Elastic Pool workers on ${label:resource_name} |
| 123 | info: Worker thread utilization of SQL Elastic Pool ${label:resource_name} \ |
| 124 | in ${label:resource_group} (${label:region}). \ |
| 125 | Exhausting workers causes query failures |
| 126 | to: dba |
| 127 | |
| 128 | template: am_sql_elastic_pool_sessions |
| 129 | on: azure_monitor.sql_elastic_pool.resource_utilization |
| 130 | class: Utilization |
| 131 | type: Database |
| 132 | component: Azure SQL Elastic Pool |
| 133 | lookup: average -5m unaligned of sessions |
| 134 | units: percentage |
| 135 | every: 1m |
| 136 | warn: $this > (($status >= $WARNING) ? (70) : (80)) |
| 137 | crit: $this > (($status == $CRITICAL) ? (80) : (90)) |
| 138 | delay: down 5m multiplier 1.5 max 1h |
| 139 | summary: SQL Elastic Pool sessions on ${label:resource_name} |
| 140 | info: Session utilization of SQL Elastic Pool ${label:resource_name} \ |
| 141 | in ${label:resource_group} (${label:region}). \ |
| 142 | Exhausting sessions prevents new connections |
| 143 | to: dba |
| 144 | |
| 145 | # --- Storage Utilization --- |
| 146 | |
| 147 | template: am_sql_elastic_pool_storage_used |
| 148 | on: azure_monitor.sql_elastic_pool.storage_utilization |
| 149 | class: Utilization |
| 150 | type: Database |
| 151 | component: Azure SQL Elastic Pool |
| 152 | lookup: average -5m unaligned of used |
| 153 | units: percentage |
| 154 | every: 1m |
| 155 | warn: $this > (($status >= $WARNING) ? (75) : (85)) |
| 156 | crit: $this > (($status == $CRITICAL) ? (85) : (95)) |
| 157 | delay: down 5m multiplier 1.5 max 1h |
| 158 | summary: SQL Elastic Pool storage used on ${label:resource_name} |
| 159 | info: Data storage utilization of SQL Elastic Pool ${label:resource_name} \ |
| 160 | in ${label:resource_group} (${label:region}). \ |
| 161 | Reaching the storage limit prevents data inserts and updates |
| 162 | to: dba |
| 163 | |
| 164 | template: am_sql_elastic_pool_storage_allocated |
| 165 | on: azure_monitor.sql_elastic_pool.storage_utilization |
| 166 | class: Utilization |
| 167 | type: Database |
| 168 | component: Azure SQL Elastic Pool |
| 169 | lookup: average -5m unaligned of allocated |
| 170 | units: percentage |
| 171 | every: 1m |
| 172 | warn: $this > (($status >= $WARNING) ? (80) : (90)) |
| 173 | delay: down 5m multiplier 1.5 max 1h |
| 174 | summary: SQL Elastic Pool storage allocated on ${label:resource_name} |
| 175 | info: Allocated data storage utilization of SQL Elastic Pool ${label:resource_name} \ |
| 176 | in ${label:resource_group} (${label:region}). \ |
| 177 | Allocated space can exceed used space due to database file growth settings |
| 178 | to: dba |
| 179 | |
| 180 | # --- In-Memory OLTP --- |
| 181 | |
| 182 | template: am_sql_elastic_pool_xtp_storage |
| 183 | on: azure_monitor.sql_elastic_pool.xtp_storage |
| 184 | class: Utilization |
| 185 | type: Database |
| 186 | component: Azure SQL Elastic Pool |
| 187 | lookup: average -5m unaligned of average |
| 188 | units: percentage |
| 189 | every: 1m |
| 190 | warn: $this != nan AND $this > (($status >= $WARNING) ? (70) : (80)) |
| 191 | crit: $this != nan AND $this > (($status == $CRITICAL) ? (80) : (90)) |
| 192 | delay: down 5m multiplier 1.5 max 1h |
| 193 | summary: SQL Elastic Pool In-Memory OLTP storage on ${label:resource_name} |
| 194 | info: In-Memory OLTP storage utilization of SQL Elastic Pool ${label:resource_name} \ |
| 195 | in ${label:resource_group} (${label:region}). \ |
| 196 | Only relevant when In-Memory OLTP is enabled |
| 197 | to: dba |
| 198 | |
| 199 | # --- Tempdb --- |
| 200 | |
| 201 | template: am_sql_elastic_pool_tempdb_log |
| 202 | on: azure_monitor.sql_elastic_pool.tempdb_log_utilization |
| 203 | class: Utilization |
| 204 | type: Database |
| 205 | component: Azure SQL Elastic Pool |
| 206 | lookup: average -5m unaligned of average |
| 207 | units: percentage |
| 208 | every: 1m |
| 209 | warn: $this > (($status >= $WARNING) ? (70) : (80)) |
| 210 | crit: $this > (($status == $CRITICAL) ? (80) : (90)) |
| 211 | delay: down 5m multiplier 1.5 max 1h |
| 212 | summary: SQL Elastic Pool tempdb log on ${label:resource_name} |
| 213 | info: Tempdb transaction log utilization of SQL Elastic Pool ${label:resource_name} \ |
| 214 | in ${label:resource_group} (${label:region}). \ |
| 215 | High tempdb log usage can block transactions |
| 216 | to: dba |
| 217 | |
| 218 | # --- Serverless --- |
| 219 | |
| 220 | template: am_sql_elastic_pool_serverless_cpu |
| 221 | on: azure_monitor.sql_elastic_pool.serverless_utilization |
| 222 | class: Utilization |
| 223 | type: Database |
| 224 | component: Azure SQL Elastic Pool |
| 225 | lookup: average -5m unaligned of cpu |
| 226 | units: percentage |
| 227 | every: 1m |
| 228 | warn: $this != nan AND $this > (($status >= $WARNING) ? (75) : (85)) |
| 229 | crit: $this != nan AND $this > (($status == $CRITICAL) ? (85) : (95)) |
| 230 | delay: down 5m multiplier 1.5 max 1h |
| 231 | summary: SQL Elastic Pool serverless CPU on ${label:resource_name} |
| 232 | info: App CPU utilization of serverless SQL Elastic Pool ${label:resource_name} \ |
| 233 | in ${label:resource_group} (${label:region}). \ |
| 234 | Only relevant for serverless tier elastic pools |
| 235 | to: dba |
| 236 | |
| 237 | template: am_sql_elastic_pool_serverless_memory |
| 238 | on: azure_monitor.sql_elastic_pool.serverless_utilization |
| 239 | class: Utilization |
| 240 | type: Database |
| 241 | component: Azure SQL Elastic Pool |
| 242 | lookup: average -5m unaligned of memory |
| 243 | units: percentage |
| 244 | every: 1m |
| 245 | warn: $this != nan AND $this > (($status >= $WARNING) ? (80) : (90)) |
| 246 | crit: $this != nan AND $this > (($status == $CRITICAL) ? (90) : (95)) |
| 247 | delay: down 5m multiplier 1.5 max 1h |
| 248 | summary: SQL Elastic Pool serverless memory on ${label:resource_name} |
| 249 | info: App memory utilization of serverless SQL Elastic Pool ${label:resource_name} \ |
| 250 | in ${label:resource_group} (${label:region}). \ |
| 251 | Only relevant for serverless tier elastic pools |
| 252 | to: dba |