SQL: DATABASE UNAVAILABLE TO QUERY
Sometimes, an MSSQL database becomes inaccessible for executing queries while remaining accessible for viewing data. …
ORACLE: LONG RUNNING QUERIES
An Oracle long-running query is one that takes a significant amount of time to execute,…
ORACLE: BACKUP FAILURE
Oracle Recovery Manager (RMAN) is the standard and most commonly used type of backup program…
ORACLE: SESSION LIMIT
Oracle session limit refers to the maximum number of available connections allowed for a particular…
TSQL: KILL PROCESS
AimBetter tracks the number of queries that have been terminated by a ‘KILL’ command. The…
SQL: DATABASE STATUS
SQL Server database possible statuses are as follows: EMERGENCY: A user has changed the database…
SQL: SESSION CPU WAIT COUNT
This metric provides the number of queries SQL Server reports waiting for CPU availability. There…
SQL: EXCEPTIONS
SQL exceptions occur when a query has been executed but cannot be completed. The proper…
MSSQL: INTERNAL MEMORY PRESSURE
SQL Internal memory pressure is an SQL Memory metric that measures memory used by the…
INCREASE IN QUERIES EXCECUTIONS
This alert provides data about queries running within a specific range of seconds. When there’s…
