Query Details
Poor Perf Query
Query
//Identifying possibly poor performing queries LAQueryLogs | where ResponseRowCount < 200 and ResponseDurationMs > 5000
Explanation
This query is looking for logs of queries that have a low number of rows in the response (less than 200) and a long duration (more than 5000 milliseconds). These queries are potentially poor performing.
Details
Rod Trent
Released: December 3, 2021
Tables
LAQueryLogs
Keywords
LAQueryLogs,ResponseRowCount,ResponseDurationMs
Operators
where<>and