Queries

MS-SQLQueriesSQL

SQL: DEADLOCK

A deadlock occurs when two or more processes compete for exclusive access to a resource but cannot obtain it because…
PerformanceQueriesSQL

QUERIES BLOCKED

Symptoms: Users report that some process has stopped or timed-out. Impact: Medium This alert means that some unidentified query has…
block
MS-SQLQueriesSQL

SQL: BLOCK

Background Blocking occurs when one process holds a lock on a specific resource and a second one attempts to acquire…
MS-SQLQueriesSQL

SQL: LOG GROWTH

Symptoms: Transaction log size has increased faster than the designated threshold rate. Impact: High AimBetter metric uses the predicted log…
MS-SQLQueriesSQL

SQL: QUERIES RUNNING LONG

Symptoms:¬†Queries are running longer than expected Impact: High Slow SQL responses will degrade the user experience, resulting in poor efficiency…
MS-SQLQueriesSQL

SQL: EXCEPTIONS

Symptoms: Incorrect coding may cause SQL errors when executing. Impact: Medium SQL Exceptions will interrupt user flow, and potentially may…
AimBetter Site | Business smart solution
MS-SQLQueriesSQL

TSQL: KILL PROCESS

Metric: Count of processes that have been killed. Impact: Informational AimBetter tracks the number of queries that have been terminated…
Menu