KBI 311422 Enhancement: Changing Runaway Query Criterion In Argent for SQL Server Runaway Query Rules

Version

Argent Advanced Technology 3.1A-1601-T14 and later

Date

Friday, 24 June 2016

Summary

Enhanced the Rule ‘Runaway Query Rules’ in Argent for SQL Server to consider maximum elapsed time instead of total elapsed time as the criterion to decide runaway queries

Technical Background

Runaway Query Rules in Argent for SQL Server fires Alert when a query with execution time greater than the specified value is found

This Rule uses the value of total_elapsed_time field in the sys.dm_exec_query_stats view as the criterion to decide runaway queries

This Rule is enhanced to use the value of max_elapsed_time field as the new criterion instead of total_elapsed_time since max_elapsed_time is the better criterion to decide runaway queries

Resolution

Upgrade to Argent Advanced Technology 1601-T14 or later