cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Give the ability to drill down by database, machine, user across a time period instead of within a time period

Give the ability to drill down by database, machine, user across a time period instead of within a time period

I'd be interested in having the ability to drill down by database, machine, user across a time period instead of within a time period. For instance, seeing only the performance information for a single database,user,machine over a day, hour, etc.  In the current setup, it's challenging to try to determine the differences in performance over a specific time frame for these items since the charts get skewed by all of the other items in the list. Let me know your thoughts or if I should provide further clarification.

5 Comments
Level 11

comment add by Kathy from layfnatu2

Level 12

layfnatu2, I think I understand what you are asking for.  Let me know if you don't think I've captured it correctly. 

I would describe it as the ability to simultaneously filter and pivot wait time by multiple dimensions.  Kind of like using an Excel pivot table to query an SSAS cube.

Level 8

This would  be beneficial to us as well. We have 20-30 databases. I would like to make a performance improvement in one database and see the effect on the one database  before applying to all of the databases.

Level 9

Selectable statistics collection phase.

We have hundreds of databases and to collect data for a longer historical period across the board would be a huge undertaking storage and network wise.
The idea has merit though as I too noticed that it is difficult to make decisions on just 24 hrs of data.

Considering what is required relates only to occasional circumstances then perhaps if we could, when required, select to collect data over a longer period and select that period e.g. few-days, week, month. This would then collect a small set of data on a single-few items that would assist our diagnostics and save on resources  e.g. network, CPU and storage.

Whilst making manual images of this week's Friday run statistics to compare with the next nothing competes with live data.

Community Manager
Community Manager
Status changed to: Open for Voting