Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

List of top Logical read queries

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

Find more posts tagged with

Accepted answers

dkranes

Yeah, it is in the ignite schema. I will try fully qualifying it.

Thank you,

David

All comments

mandevil

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.

dkranes

Thank you Robert. I will have a look.

David

dkranes

When I execute stored procedure TopSQLByMetric referenced above, I get the following error:

Msg 208, Level 16, State 1, Procedure TopSQLByMetric, Line 28

Invalid object name 'COND'.

David

mandevil

Might need to fully qualify it. Who owns the objects in your repo?

Maybe try it from the query tool inside DPA - options -> support tab -> Database Query Tool (should query against the repo by default)