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.
Resource utilisation per query can be seen in the top 10 queries view on the SQL Instance overview
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?