Thanks Nick! Yes Data Services Manager (DSM) does provide the kind of perspective Pari is looking for but not for Phoenix. Actually, if Phoenix is providing metrics and information in a repository or via a REST interface, on queries, elapsed times, etc. then certainly it could be incorporated into DSM. Trafodion is doing that now in R1.0 and we are working on having DSM provide full support for Trafodion along with complete support for HBase (some of it being already there), in order to provide a comprehensive view of all workloads from HDFS, HBase, to SQL. We did have plans to provide a SDK so that data services like Phoenix could be easily plugged into DSM. Not a hard task – just time and effort ☺.
If Pari is interested, we can certainly demo the tool and go from there based on interest. Rohit From: Nick Dimiduk [mailto:ndimi...@gmail.com] Sent: Wednesday, February 11, 2015 9:01 AM To: dev@phoenix.apache.org Cc: Jain, Rohit (Trafodion) Subject: Re: Phoenix monitoring Hi Pari, I'm not aware of a Phoenix-aware, end-to-end solution here. You can probably write a custom collector for a Phenox application that can report into OpenTSDB; I think JDBC metrics are available via JMX. That would be a great addition for that project! I've also seen a product demo from HP that does a lot of this for other tools on HBase, though I don't think it supports Phoenix yet (cc Rohit). Thanks, Nick On Wednesday, February 11, 2015, Pariksheet Barapatre <pbarapa...@gmail.com<mailto:pbarapa...@gmail.com>> wrote: Hello All, Can you suggest good monitoring tool for phoenix. Our QA hbase cluster is crashing randomly. We wanted to know stats like which query causing the issue and how many queries running on that particular time window, resource consumption of query etc. Cheers Pari
