Skip to content

In Redgate Monitor, I want to...

← Suggestions

Allow drilldrown capability for different resource areas

It would be nice to be able to see which sql statements or db users were generating the most CPU usage, RAM usage, and Disk IO. This would help us quickly identify bottlenecks on the system.

CLR statistics would be nice to have too since we have found that it can account for locking issues in certain circumstances.

5 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Caleb shared this idea  ·   ·  Report…  ·  Admin →
completed  ·  Daniel Rothig responded  · 

Resource utilisation per query can be seen in the top 10 queries view on the SQL Instance overview

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminAdam (User Experience Specialist, Red Gate Software) commented  ·   ·  Report

    Hi Caleb,

    Thanks for the suggestion. It's prompteed a few more questions so we can better understand the requirements...

    Has the Top 10 Expensive Queries feature been useful? Currently on the instance and database overviews you can sort the top 10 expensive queries by CPU use time, reads and writes.

    db users - at the moment we show by SQL process. Would an aggregate by user be sufficient for what you want to see?

    CLR stats - are there any stats in particular and how are you currently getting them?

Suggestions

Categories

Feedback and Knowledge Base

(thinking…)