Longest running queries

crimdon

Is it possible to see the longest running queries per server? The current report only appears to show this for the entire estate.

Regards

Andrew

Russell D

If you create a report/add a summary tile for LRQs,  you should also see a drop down box to choose the server. I'm going to assume this isn't what you want, but a break down of each server on the same report? In which case it isn't possible I'm afraid. Reports work is on the backlog so I'd add it here: https://sqlmonitor.uservoice.com/forums/91743-suggestions for consideration.