<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Take a look at the mondrian.server.monitor package if you haven’t already. This infrastructure is intended to capture some the information you’re looking for. That said, there are at least some bugs where metrics are captured incorrectly (e.g. <a href="http://jira.pentaho.com/browse/MONDRIAN-1449">MONDRIAN-1449</a>). The features has not been used much to date. It also requires programmatic access to read the metrics—you need to have a connection object in order to read monitoring data. I’d love to see this data exposed via JMX (<a href="http://jira.pentaho.com/browse/MONDRIAN-1448">MONDRIAN-1448</a>) and through pentaho BI (<a href="http://jira.pentaho.com/browse/MONDRIAN-857">MONDRIAN-857</a>). I believe new relic supports JMX, so that might be an option for you if 1448 gets implemented.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Vote for Jira cases if any of the above would help you, and add new ones if you find bugs or missing use cases.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> mondrian-bounces@pentaho.org [mailto:mondrian-bounces@pentaho.org] <b>On Behalf Of </b>Oren Mazor<br><b>Sent:</b> Sunday, March 03, 2013 8:30 PM<br><b>To:</b> mondrian@pentaho.org<br><b>Subject:</b> [Mondrian] Monitoring Mondrian<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Hey all,<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I built a stack on top of mondrian using pg and rails. I monitor the rails app using new relic, but once a request goes into mondrian, its a black hole. what would you recommend for monitoring?<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>The questions I want to ask is:<o:p></o:p></p></div><div><p class=MsoNormal> - did this query hit the cache?<o:p></o:p></p></div><div><p class=MsoNormal> - how much cache got loaded by this query?<o:p></o:p></p></div><div><p class=MsoNormal> - how long did each step take?<o:p></o:p></p></div><div><p class=MsoNormal> - what does the jvm look like at this stage?<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I feel like editing the mondrian source code to push to newrelic (or statsd) with custom instrumentation is a step in the wrong direction.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>between splunk and a variety of jvm debug tools I have something going, but I think there's a better way that I dont know about.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>thanks for your help!<o:p></o:p></p></div><div><p class=MsoNormal>Oren<o:p></o:p></p></div></div></div></body></html>