How do you use cloud databases? Take the survey.

For TOP 10 Queries, where can we find the host and SPID/session_id of the connection?

PeterDanielsCRBPeterDanielsCRB Posts: 126 Bronze 3
in SQL Monitor
SQL Monitor 9.2.0.23782.

I'm looking at one of the TOP 10 Queries.  I'm wondering where I can find the query's connection's host and SPID?  I's also not seeing when the query started and finished.  Am I missing something?
Tagged:
· Share on Twitter

Answers

  • Russell DRussell D Posts: 1,324 Diamond 5
    edited February 10, 2020 2:43PM
    Hi Peter, we dont show connection host/SPIDs on top ten queries because we are not sure if it makes sense to do so. Eg you could be looking at a TTQ run 100 times and so it's not entirely clear what to show here. Ie the last run information, or results for all queries, etc.
    Have you visited our Help Centre?
    · Share on Twitter
  • PeterDanielsCRBPeterDanielsCRB Posts: 126 Bronze 3
    Thanks, @Russell D.  That makes sense to me, even if it's not the answer I wanted.  I'd still like a way to get around that and see various "instances" of the query execution like I can in SQL Sentry.  Every time I feel the need to set up an XE trace to get to the details I need for RCA, I wonder if SQL Monitor is just missing some functionality.  Perhaps I am expecting too much.  How do you recommend I dive deeper when I want to correlate what I'm seeing in SQL Monitor with actual query events?
    · Share on Twitter
Sign In or Register to comment.