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

Is there a way to see a longer list of the "most executed" sql statements in the current view?

Is there a way to see a longer list of the "most executed" sql statements in the current view? We have a system with a lot of OLTP transactions going on and it would be great to be able to see the top 500 most executed statements.

Find more posts tagged with

Accepted answers

All comments

mandevil

In the UI, that specific functionality is limited. What DB are you using as the repo? SQL or Oracle?

victora

SQL Server.

mandevil

Check out this custom report (really just a query against the repo): Custom Report - Top SQL by Any Metric

One of the choices is by executions. I think you can use it or even tweak it a bit to get the data you want since the UI is limited...