Total data file size/used metrics - add filegroup level
CONTEXT: We have some databases with multiple filegroups, I’d be useful to be able to drill down from the DB level to the FG level on the “Total data file size” and “Total data file used” metrics.
PROBLEM: Not being able to slice totals by FG is problematic, since different FGs often have different capacity / performance requirements, different space used speed/patterns etc.
EXAMPLE SOLUTION: For “Total data file size” and “Total data file used” add an additional selector window after the database selector: a list of filegroups + an (All) option at the top. So, the selectors would be: machine->instance->DB->FG
-
PL commented
-
Blaž Dakskobler commented
@Redgate: Consider adding these votes to https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/33130783-total-data-file-size-used-metrics-add-filegroup
It's not identical, but close enough.
-
Anonymous commented
Hello Team,
I am looking for File and Filegroup Monitoring in SQL Monitor.
So in the User Interface, i can see Each File group, The Number of Files in the Filegroup and Free and Used space by Each File in the Filegroup.
Thanks and Regards,
Mahesh Deshpande