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

Hi Samuel,
We've noticed your problem and suggestion, and our team will reply you ASAP after carefully checking. Thanks.

------------------------------
LI HUI YAN
------------------------------

Hi Samuel,

"Storage" metric supports history mode as well as realtime mode. By default, the backend collection would occur every 24 hours, and the collected data would be stored in repo DB. So, when you switch to history mode (e.g., last 3 days), all the contained data would be listed. If you see nothing is shown, it may be problematic. Did you changed any default monitor profile settings? If you believe console behaves unexpectedly, could you provide more detailed info and we'll try to investigate the issue. Li Hui may help assist you if necessary. thanks.

@zhenling , please​ feel free to comment about it, thanks.

------------------------------
KAI DING
------------------------------

Hi Kai and Li, thanks

Good to know that this is expected to work in historical mode. No I haven't changed anything in profile settings related to this. 
I am not sure what happened when I tried this by the first time. I saw no other "collect time" besides the last one, regardless the time-frame interval. 

Anyway, few things noticed in this view.. 

1. System objects filter not applied by default. 
"Show system objects" is not enabled/clicked,  and the grid shows system tables. 




------------------------------
Samuel Pizarro
------------------------------

Original Message:
Sent: Mon December 02, 2019 01:55 AM
From: KAI DING
Subject: Monitor - Storage - Tables/Schema not historical

Hi Samuel,

"Storage" metric supports history mode as well as realtime mode. By default, the backend collection would occur every 24 hours, and the collected data would be stored in repo DB. So, when you switch to history mode (e.g., last 3 days), all the contained data would be listed. If you see nothing is shown, it may be problematic. Did you changed any default monitor profile settings? If you believe console behaves unexpectedly, could you provide more detailed info and we'll try to investigate the issue. Li Hui may help assist you if necessary. thanks.

@zhenling , please​ feel free to comment about it, thanks.

------------------------------
KAI DING
------------------------------

@Samuel Pizarro Glad to know you like heat-map which we are planning to get it back in DMC as well.  Thanks!​

------------------------------
HAO WU
------------------------------

Original Message:
Sent: Mon December 02, 2019 08:15 PM
From: Samuel Pizarro
Subject: Monitor - Storage - Tables/Schema not historical

Hi Kai and Li, thanks

Good to know that this is expected to work in historical mode. No I haven't changed anything in profile settings related to this. 
I am not sure what happened when I tried this by the first time. I saw no other "collect time" besides the last one, regardless the time-frame interval. 

Anyway, few things noticed in this view.. 

1. System objects filter not applied by default. 
"Show system objects" is not enabled/clicked,  and the grid shows system tables. 

2.  Some tables showing invalid dates for "Last used" column.   0000-12-29 22:00:00

3. What is the default retention for this ? 

4. If I try to order the grid by table-name,  so I can see all collected times for same table all together, to analyze the evolution,  I get the following error. 

HWCMON0006E: The sort control metric is invalid. Specify a valid metric and try again. You can find all the supported metrics from the returned data. If it's your first time to run the API, you do not have to set this parameter. The response will show all the supported metrics.

Ordering by schema name is possible, but the result-set is not too useful as the tables get randomly ordered in the grind. 
It would be nice if we could apply multiple sort levels on all these grids..  
Today they are pretty limited to only one single level of sorting. 

-----
These were what I could detect in a few tests..  

The request for graphs still stands..  hope you guys can consider implementing this in the future.. 

One last question..  

I am missing the "heat-map"  we had on DSM.  Is it coming back ? 

------------------------------
Samuel Pizarro
------------------------------


Original Message:
Sent: Mon December 02, 2019 01:55 AM
From: KAI DING
Subject: Monitor - Storage - Tables/Schema not historical

Hi Samuel,

"Storage" metric supports history mode as well as realtime mode. By default, the backend collection would occur every 24 hours, and the collected data would be stored in repo DB. So, when you switch to history mode (e.g., last 3 days), all the contained data would be listed. If you see nothing is shown, it may be problematic. Did you changed any default monitor profile settings? If you believe console behaves unexpectedly, could you provide more detailed info and we'll try to investigate the issue. Li Hui may help assist you if necessary. thanks.

@zhenling , please​ feel free to comment about it, thanks.

------------------------------
KAI DING

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
------------------------------

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
------------------------------

Hi,Samuel

Thanks a lot for your suggestions!

1. For quick search issue, it is an issue, we will fix it.
2. For chart scale, we will try to adjust properly for it.
3. For plot for TOP N tables in a particular time frame, about the new requirement,  @Li Hui Yan,  would you please help open an issue for the new requirement replacing RFE for designer? Thanks!​​

------------------------------
SHUANG LI
------------------------------

Original Message:
Sent: Fri December 13, 2019 04:25 PM
From: Samuel Pizarro
Subject: Monitor - Storage - Tables/Schema not historical

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