dbanalys-graph, useful or duplication of effort ?

Posted by cverbiest on 09-Jul-2015 10:34

I created a google graph treemap based on the output of proutil -C dbanalys.

https://cdn.rawgit.com/cverbiest/dbanalys-charts/master/sample/sports2000.tab.html

It's in an early stage, I don't wont to spend more time on this if something similar already exists.

I'll put it on codeshare if it seems useful .

All Replies

Posted by James Palmer on 09-Jul-2015 10:37

Looks interesting that.

Posted by Rob Fitzpatrick on 09-Jul-2015 10:38

Very cool!  If such a thing exists already, I haven't seen it.  I'd love to have the code if you're willing to share.

Posted by Thomas Mercer-Hursh on 09-Jul-2015 10:42

Check out www.progresstalk.com/.../how-much-free-information-is-too-much.140432 for ideas and possible cross fertilization.

Posted by cverbiest on 09-Jul-2015 10:44

The code is available at https://github.com/cverbiest/dbanalys-charts

Posted by cverbiest on 09-Jul-2015 10:54

Thanks, interesting link

Posted by TheMadDBA on 09-Jul-2015 10:57

Looks interesting to say the least. I could definitely see this expanded to show more information about each area/table... especially which objects are in need of a tablemove, RPB change or index rebuilds.

Posted by Rob Fitzpatrick on 09-Jul-2015 11:40

Another possible future enhancement is to read data from the CSV files produced in 11.4+ dbanalys with -csoutput.  They're a lot nicer than the report for programmatic parsing.

Posted by Rob Fitzpatrick on 09-Jul-2015 11:43

Sorry, I just looked at GitHub and saw you're already doing that!

Posted by James Palmer on 10-Jul-2015 05:23

Just run it against my DB. Looking good. One comment though - it doesn't take into account LOBs. I know it's bad practise to have LOBs in Data Areas, but at the moment we do, and as a result it's mis-representing the size of our biggest area by around 150GB! :)

Posted by James Palmer on 10-Jul-2015 05:30

Of course LOBs aren't reflected in dbanalys - I forgot that was a shortfall PSC haven't addressed yet.

This thread is closed