Top N slowest queries from AppInsights

[PeerMohamedMydeenA]

I'm looking for a way to build a report for top N slowest queries, slowest queries by entities, duration, result size etc.

When I looked at the telemetry generated by DAB, I find the SQL queries generated by DAB from the graphql query in traces and no way to tie that to the requests to find the slowest queries.

Is there any other way to capture the original grphql query and the duration ?

[seantleonard]

Hi @PeerMohamedMydeenA , while we don't have that today, @JerryNixon is working on list of stats /perf counters to collect and which would be most useful.

[yorek]

If you are using MSSQL, you can use regular monitoring tools like Performance Insights or using performance system views. Would be that a good alternative for now?

[PeerMohamedMydeenA]

@yorek, this is certainly a good alternate in case of MSSQL. We are also looking into using DAB with CosmosDB as a variation in platform offering. Having these metrics unified onto AppInsights would help us building Reports out of Log Analytics.