SQL: LOGIN FAILED ATTEMPT16 Oct 2023A Login exception is a failed attempt to log in to the database instance during…
QUERIES BLOCKED16 Oct 2023A blocked query is a database query waiting for the blocking query to complete its…
MSSQL: BATCH REQUEST15 Oct 2023In SQL Server, a query is processed as a batch request. A Batch represents the…
MSSQL: JOB CANCELLED30 Aug 2023There are three situations where jobs can be cancelled. A user can cancel a job…
SQL: USER CONNECTIONS14 Aug 2023A connection is a new session established with the SQL Server Database Engine. It might…
SQL: DATA GROWTH14 Aug 2023Data growth refers to an increase in the amount of the database’s data files. For…
SQL: LOG GROWTH10 Aug 2023This metric is intended to identify any case where the transaction log file has grown…
SQL: QUERIES OPEN TRANSACTION10 Aug 2023Transactions are committed by SQL when successful or rolled back when not (if they encounter…
SQL: BLOCKING QUERIES9 Aug 2023A blocking query is a database query that causes other queries or transactions to wait…
SQL: LONG RUNNING QUERIES25 Jul 2023A SQL Server long-running query is one that takes a significant amount of time to…