Is there a way in DPA to see the top logical read queries? We have a very low page life expectancy on one of our servers and need this to investigate.
Thank you,
David Kranes
Very Timely. Couple of options currently: Custom Report - Top SQL by Logical I/O per Execution
or: Custom Report - Top SQL by Any Metric
The top SQL by any metric should do nicely for your request. Or tweak it for your own use. You can bracket the timeframes where PLE is low.
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.