Hi @SHUANG LI
Ok, several challenges here...
1. not able to filter to find interest tables. My db has around 300 user tables, and in order to find the table, I am trying to apply a filter to this grid.. Not being successful. Both options (simple "Search Schema or Table" form at left-top, or complex Filter button at top-right) simply just don't work. I am sure I am providing correct table names, but after applying the filter the result is empty grid.
2. so I gave up, and choose any table that was appearing the in the grid.
When I clicked the "View Details ..." button, I could see the trend charts..
BUT, the chats vertical scale are TERRIBLE. all charts got flattened, you cant "see" the evolution, because the scale does not help to see the evolution.
Clicked in details for the highlighted row, Please not that the time frame interval is "Last Mont"
For example, the physical size, first point is 160GB, and last one is 171GB. but the scale does not help to "see" the difference.
Scale should adjust properly for each of them.
---
Besides the challenges , its good to know we have this.. but this is table per table basis.. and the interface is not as fast as I would wish... It took me more than 10 minutes to find a good table, (scrolling the grid) , and clicking the details button to have the charts plotted. )
But the request still stands, for the TOP N tables.. User could choose , one metric, for example , physical size, plotted for TOP N tables in a particular time frame. This would be awesome.
Regards
------------------------------
Samuel Pizarro
------------------------------
Original Message:
Sent: Thu December 12, 2019 02:15 AM
From: SHUANG LI
Subject: Monitor - Storage - Tables/Schema not historical
Hi Samuel,
You can click the clock icon to switch to view storage historical data.
Here we show schema/table storage information list, you can view detail of one schema/table by clicking the following icon. And in the detail page, we show the trend chart for schema/table metrics, such as 'data object logical size','index object logical size' etc. You can have a try.
------------------------------
SHUANG LI
Original Message:
Sent: Sat November 30, 2019 10:04 AM
From: Samuel Pizarro
Subject: Monitor - Storage - Tables/Schema not historical
On Monitor, Storage , Storage view
You can see tables sizes, etc.. which is pretty useful. and you have the control to scroll over the time, (look in the past). But this is useless, as it seems only the last capture in being kept on repository db. If I chose any time interval in the past, nothing is shown in the table.
Please, keep at least one capture per week, and have an option to keep the history for (n days) in the monitor profile. This would be a useful tool to analyze tables growth over the time.
And the entire db size should also be kept, not only the tables..
Today I have manual queries that I run every week to capture db-size, and top 20 tables (in size) for my dbs.
This is useful information to application team in order to plan data growth, and pruning maintenance.
If DMC could take care of this properly, it would be a nice thing to have. Specially by plotting some graphics, showing the evolution of table-sizes (just top N tables) , like 10 or 20 tables in a multi-line graph, for the last 6 months for example..
Same graph could also plot one line for the entire db size evolution. using a different scale at the right-side bar of the graph.
something like this:
the 2 dotted lines, used the right-side bar scale. in order to get a better view experience, and avoid the other lines to become flattened.
Regards
------------------------------
Samuel Pizarro
------------------------------
#Db2