Queries

QUERIES BLOCKED

A blocked query is a database query waiting for the blocking query to complete its…

MSSQL: BATCH REQUEST

In SQL Server, a query is processed as a batch request. A Batch represents the…

MSSQL: JOB FAILED

SQL agents and others that are specific to your own design requirements trigger jobs that…

MSSQL: JOB CANCELLED

There are three situations where jobs can be cancelled. A user can cancel a job…

SQL: USER CONNECTIONS

A connection is a new session established with the SQL Server Database Engine. It might…

SQL: DATA GROWTH

Data growth refers to an increase in the amount of the database’s data files. For…

SQL: LOG GROWTH

This metric is intended to identify any case where the transaction log file has grown…
Menu
Skip to content