KQL Search

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.