Database Filter on Slow Queries - Running Queries - Top Queries etc..

[RangaSQL]

It would be great if we can have a filter by Database Name, so we can focus on an individual database if needed.

[DavidWiseman]

Hi,

It's possible to filter on database name. In general navigating down to database level is the easiest way to do this.

Slow Queries

• Navigate down to the database level. It's automatically filtered for the current database.
  or
• Add the database name to the Filter menu
  or
• Group by database, then click the link in the Database column

Top Queries

• Navigate down to the database level. It's automatically filtered for the current database.

Running Queries

• Select group by Database.
• Click the link in the database_name column
  or
• Right click the Database Name column and use Filter By Value (Or Equals, Like etc)

Note: This tab isn't shown at database level. It could be shown at database level, filtering automatically for the current DB, but there is an issue to consider with this. The list of snapshots comes from RunningQueriesSummary, which would not be filtered for the current DB. It might show 30 running queries, but list 1 when selected and filtered for the current DB. Or it would need to re-calculate this information or augment it with numbers associated with the current DB. It's doable, just extra work and additional overhead displaying the list of snapshots.

---

In all cases, cross database queries can complicate evaluating activity at the database level.

Let me know if this solves your issue filtering for the current DB.

Thanks,

David