How can i find how many times a specific query executes? Like it will tell me how long it ran across all executions of a specific query, but how can i find out how many times it was executed?
When you drill down on a query hash and see the Query Performance Analysis (QPA) screen, executions (and wait time per execution) is the first line chart you'll see.
QPA is a feature of DPA 12.0. For earlier version, when you get properties, click Historical charts and you should see executions.
What's new in DPA 12.0?
We did many assisted upgrades when 12.0 came out and the upgrades typically took 10-20 minutes. The process is to download the new version, run the install and it will take care of everything for you. When you login to the SolarWinds customer portal, you should see the download for DPA 12.0. Here are the release notes which contain links to many other places and the upgrade links are near the bottom:
OK so i have upgraded to the latest 12.0.3074, i now see executions in the graph how ever it says 0 across the entire time frame, and i also see this message, "Statistics reflect changes in statistical values over the sampled time, and may be 0 or blank if the monitored database instance has not updated its published statistics." any help with this one?
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.