Alert Category (PAAS SQL DB) | Rule Description (criteria to trigger email) |
CPU | when System CPU average usage is continously greater than “N% (eg 60%)” since Current time – N minute |
Memory | when System Memory average usage is continously greater than “N% (eg 60%)” since Current time – N hour |
Low Database (Data, Log File) Space | When Database data or Log file space is found to be less than “N% (eg 30%)” space free |
connection_failed | When invalid login name , login failed for user, blocked by firewall, timout, long transaction etc occurs |
throttling_long_transaction | when excessive tempdb usage, excessive lock usage, excessive log space_usage , excessive memory usage etc occurs |
Deadlock | Whenver Deadlock occurred |