I see the top query for a day ran for 10.4 hours(accross all execution) as below and but this query is not not active but the execution time is increasing.
I see the top query for a day ran for 10.4 hours(accross all execution) as below and but this query is not not active but the execution time is increasing.
I think that screenshot is from the query Analysis screen, if so and you scroll down there will be more information on average waits per execution and execution counts. I'd guess you're having a lot executions for that query with very short duration - so you do not see it as an active session under the current activity tab.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.