Allow customisation of query execution threshold for Individual query monitoring
Individual query monitoring is currently either only catching or possible only displaying queries longer then 5 seconds. Should be great if it was possible to customise this threshold.
The ability to customise the threshold for capturing individual query executions was added in version 14.6.0.
To configure, simply go to Settings > Additional monitoring settings. Here you can enable/disable and select a threshold between 1-5 seconds for each of the instances being monitored.
-
Mark Freeman
commented
So, no support for this in Azure SQL Database? If not, do we need a new Suggestion that is specific to that environment, or will you reopen this one?
From https://documentation.red-gate.com/monitor/query-executions-273973337.html:
"Redgate Monitor supports query execution monitoring for SQL Server instances on both Windows and Linux environments, as well as Amazon RDS SQL Server Standard and Enterprise editions; we do not support query execution monitoring on the Web or Express editions of Amazon RDS SQL Server, SQL Server 2012 and SQL Server 2008 R2. "