Search
-
Provide a report on queries with suggestions on improving performance
-
see if a query plan is taken from a plan guide
-
Capture cursor SQL for long running queries
-
Data Export
-
Report that shows top 50 long running queries across the estate
-
Overview - Drill-through ability on Splits/sec to the Queries causing it
-
Automatic validation of regex for Long-running query configuration
-
Add Database Filtered in Top 10 Queries\Wait Section
-
Add filtering to the Top 10 Queries/Waits lists
-
Ability to not monitor/show certain queries in the TOP 50 list.
-
Find Queries / Stored Procs whose Performance has Decreased Over Time
-
be able to be advised if a certain query (sql_handle or query_hash) is suddenly taking much longer than normal to execute. Not only to see
-
Show Job name instead of ID in query related alerts · completed
-
Produce a long running queries report ordered by average execution time
-
I would like to give aliases to queries for easy recognition
-
Being able to filter "TOP Queries" by any of the columns
-
Add ability to collapse the "Query details"/"Wait type"/"User memory" list under a specific query.
-
Fix the column headers for the Top Queries when scrolling
-
see username and hostname in "top 50 queries" and "top 10 waits"
-
Show login and client hostname/IP address for Top Queries on PostgreSQL