4 Replies Latest reply on Mar 25, 2013 8:25 AM by rareddy

    What are the mbean details to monitor dataservices using JMX?

    ramanathan.p
    ramanathan.p Mar 22, 2013 4:47 AM

      Would like to know about the JMX mbean details that are available for monitoring dataservies using JMX.

       

      Interested to monitor following params using JMX:

       

      1. Long running queries
      2. Prepared plan Cache Hit Ratio %
      3. Result Cache Hit Ratio %
      4. Used Buffer Space

       

      Observed that above details are available in admin-console (screen-shot attached) under dataservcies section. But, would like to monitor the same using JMX inorder to trigger alerts.

       

      Please help on this.

       

      -

      Ramanathan

        • 1. Re: What are the mbean details to monitor dataservices using JMX?
          tejones
          tejones Mar 22, 2013 9:30 AM (in response to ramanathan.p)

          Ramanathan,

           

          Have you considered RHW (http://www.jboss.org/rhq)? Using the Teiid RHQ plugin that is installed in Embedded Jopr (the Admin Console from your screenshot), you can trigger alerts without having to use JMX.

           

          Here is a recording on how to monitor metrics and add alerts in JON, the product based on RHQ: http://vimeo.com/12463962 which may be helpful.

           

          Thanks,

          Ted

            • Actions
          • 2. Re: What are the mbean details to monitor dataservices using JMX?
            rareddy
            rareddy Mar 22, 2013 9:30 AM (in response to ramanathan.p)

            Ramanathan,

             

            Teiid does not provide JMX beans based administration, if you need alerts generated you need to be looking into a tool called JBoss ON (JON) which is administrative tool from Redhat. However, I believe it is only available through Redhat product subscription. If you are deploying any non-trivial application in production I would highly recommend look into subscription.

             

            Ramesh..

              • Actions
            • 3. Re: What are the mbean details to monitor dataservices using JMX?
              ramanathan.p
              ramanathan.p Mar 25, 2013 4:24 AM (in response to rareddy)

              Thanks Ted & Ramesh for the replies.

               

              We would like to use an existing monitoring tool. JON and others would mean another tool and the monitoring activity becomes complex and spread across multiple tools. Is there a roadmap of introducing MBean Framework in Tiied in the future? If yes, when it will be available?

               

              -

              Ramanathan

                • Actions
              • 4. Re: What are the mbean details to monitor dataservices using JMX?
                rareddy
                rareddy Mar 25, 2013 8:25 AM (in response to ramanathan.p)

                Ramanathan,

                 

                Unfortunately no, it is not on our current roadmap. JBoss Frameworks provide a slightly better version of JMX like frameworks that Teiid uses to expose these monitoring values. Now, you can

                • Either log an feature request in JIRA, that may get picked up in providing the functionality in future versions. Sooner if more people are requesting this!
                • or write simple extension yourself to expose these values through JMX. It should be an easy task as all the needed values are already gathered at one place for JON/CLI based administration. For simplicity, you can write an external process, that connects to Teiid through Admin API, and read these values and expose through JMX.
                • You can submit your development as contribution to Teiid,  we can integrate into main line  Teiid.

                 

                Ramesh..

                  • Actions