AZURE SQL PAAS DB Alert List

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
Memorywhen System Memory average usage is continously greater than “N% (eg 60%)” since Current time – N hour
Low Database (Data, Log File) SpaceWhen Database data or Log file space is found to be less than “N% (eg 30%)” space free
connection_failedWhen invalid login name , login failed for user, blocked by firewall, timout, long transaction etc occurs
throttling_long_transactionwhen excessive tempdb usage, excessive lock usage, excessive log space_usage , excessive memory usage etc occurs
DeadlockWhenver Deadlock occurred

Leave a Comment

Your email address will not be published. Required fields are marked *