Monitoring and alerting can be overwhelming tasks, especially for those new to the world of managing production data. One common challenge for any data professional is the identification and management of queries that run for longer than they should.
Long-running queries pose immediate challenges as they can impact availability, performance, and even data security. Unexpected high-duration workloads can contribute to excessive IO, waits, locking, blocking, and other problems that can lead to application downtime.
This article dives into a variety of ways to identify, manage, and alert on long-running database queries for free using nothing more than T-SQL and some