Poor Perf Query
Query
//Identifying possibly poor performing queries
LAQueryLogs
| where ResponseRowCount < 200 and ResponseDurationMs > 5000Explanation
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
LAQueryLogsResponseRowCountResponseDurationMs
Operators
where<>and