SQL: SESSION AVERAGE WAIT SIGNAL
In SQL Server, session wait times measure how long a session waits for resources before…
MSSQL: REPLICATION LATENCY
SQL Server replication is the mechanism for copying and distributing data and database objects from…
AZURE/AMAZON RDS: STORAGE AVAILABLE SPACE
Azure storage available space refers to the amount of cloud storage for database data provided…
SQL: DATABASE UNAVAILABLE TO QUERY
Sometimes, an MSSQL database becomes inaccessible for executing queries while remaining accessible for viewing data.…
AZURE: MAX WORKER
Azure Max Worker measures the total task load performed by the cloud instance. The impact…
AZURE: DTU UTILIZATION
Higher DTU utilization indicates that the Azure SQL Database is consuming more resources than expected.…
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: JOB FAILED
Scheduled jobs in a database system (such as SQL Server Agent jobs or Oracle DBMS_SCHEDULER…
SQL: SESSION CPU WAIT COUNT
This metric provides the number of queries SQL Server reports waiting for CPU availability. There…
