<div dir="ltr"><div class="gmail_extra"><div><div class="gmail_signature" data-smartmail="gmail_signature"><br></div></div>
<br><div class="gmail_quote">On Thu, Feb 16, 2017 at 10:46 PM, Subramanian, Karthikeyan <span dir="ltr"><<a href="mailto:Karthikeyan_Subramanian@intuit.com" target="_blank">Karthikeyan_Subramanian@intuit.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="white" lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="m_2410991217203268825WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt">Hi ALL,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">How do you get the “Query Per second” dashboard for monitoring? Trying to set up monitoring for the below threshold.<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt">7000 queries per second - alert<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt">10000 queries per second few drops<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">14000 queries per second - significant drops</span><span style="font-size:10.0pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">I have checked in bind “</span><span style="font-size:10.0pt;color:black">statistics-channels” for QPS.I don’t see any stats for QPS.</span><span style="font-size:10.0pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">Thanks<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt">Karthikeyan.S<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman""></span></p></div></div><br></blockquote><div><br></div><div>The statistics give you queries since the process was started. You will need to read at intervals, subtract the previous value from the current value, and divide by the time to get QPS.</div><div><br></div><div>-- </div><div>Bob Harold</div><div> </div></div><br></div></div>