System Predictive Dashboard [ Edited ]

[#1]

This dashboard leverages the Infoblox specialized Exponential Moving Maximum (EMM) forecast commands to predict when a selected grid member will meet its QPS or LPS thresholds. Select your grid member, then select the model and it will provide the predictions and visualizations

<form>
  <label>System Predictive Dashboard</label>
  <fieldset submitButton="false" autoRun="true">
    <input type="dropdown" token="grid_member_var" searchWhenChanged="true">
      <label>Grid Member</label>
      <search>
        <query>index=ib_dns_summary report=si_dns_member_qps_trend | stats count by orig_host</query>
      </search>
      <fieldForLabel>orig_host</fieldForLabel>
      <fieldForValue>orig_host</fieldForValue>
    </input>
    <input type="dropdown" token="member_type" searchWhenChanged="true">
      <label>Select Member Type</label>
      <choice value="type_t810">Trinzic 810</choice>
      <choice value="type_t820">Trinzic 820</choice>
      <choice value="type_t1410">Trinzic 1410</choice>
      <choice value="type_t1420">Trinzic 1420</choice>
      <choice value="type_t2210">Trinzic 2210</choice>
      <choice value="type_t2220">Trinzic 2220</choice>
      <choice value="type_t4010">Trinzic 4010</choice>
      <choice value="type_t4030">Trinzic 4030</choice>
      <change>
        <condition value="type_t810">
          <set token="qps_threshold">4000</set>
          <set token="lps_threshold">60</set>
        </condition>
        <condition value="type_t820">
          <set token="qps_threshold">15000</set>
          <set token="lps_threshold">105</set>
        </condition>
        <condition value="type_t1410">
          <set token="qps_threshold">30000</set>
          <set token="lps_threshold">210</set>
        </condition>
        <condition value="type_t1420">
          <set token="qps_threshold">50000</set>
          <set token="lps_threshold">300</set>
        </condition>
        <condition value="type_t2210">
          <set token="qps_threshold">61000</set>
          <set token="lps_threshold">375</set>
        </condition>
        <condition value="type_t2220">
          <set token="qps_threshold">143000</set>
          <set token="lps_threshold">600</set>
        </condition>
        <condition value="type_t4010">
          <set token="qps_threshold">200000</set>
          <set token="lps_threshold">1020</set>
        </condition>
        <condition value="type_t4030">
          <set token="qps_threshold">1000000</set>
          <set token="lps_threshold">0</set>
        </condition>
      </change>
    </input>
  </fieldset>
  <row>
    <panel>
      <title>DNS Thresholds</title>
    </panel>
  </row>
  <row>
    <panel>
      <single>
        <title>Max QPS</title>
        <search>
          <query>index=* |head 1| eval max=$qps_threshold$|table max</query>
          <earliest>0</earliest>
          <latest></latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">none</option>
        <option name="numberPrecision">0</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="useColors">0</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="drilldown">none</option>
      </single>
    </panel>
    <panel>
      <single>
        <title>QPS Threshold Prediction</title>
        <search>
          <query>index=ib_dns_summary report=si_dns_member_qps_trend            (orig_host="$grid_member_var$")            *         | timechart bins=1000 eval(avg(QCOUNT)/600) by orig_host where max in top5 useother=f            | interpolate 1200 | emm $grid_member_var$ |predict emm future_timespan=150 as prediction             |where prediction&gt;=$qps_threshold$              | sort _time              | head 1              | eval month_year=strftime(_time,"%B %d %Y")              |table month_year</query>
          <earliest>-1y</earliest>
          <latest>now</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">none</option>
        <option name="numberPrecision">0</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="useColors">0</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="drilldown">none</option>
      </single>
    </panel>
  </row>
  <row>
    <panel>
      <chart>
        <title>QPS Prediction</title>
        <search>
          <query>index=ib_dns_summary report=si_dns_member_qps_trend            (orig_host="$grid_member_var$")            *                | timechart bins=1000 eval(avg(QCOUNT)/600) by orig_host           | interpolate 1200 |emm $grid_member_var$| forecast emm future_timespan=90 as prediction             | eval Max_QPS=$qps_threshold$</query>
          <earliest>-1y@y</earliest>
          <latest>now</latest>
        </search>
        <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
        <option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option>
        <option name="charting.axisTitleX.visibility">visible</option>
        <option name="charting.axisTitleY.visibility">visible</option>
        <option name="charting.axisTitleY2.visibility">visible</option>
        <option name="charting.axisX.scale">linear</option>
        <option name="charting.axisY.scale">linear</option>
        <option name="charting.axisY2.enabled">0</option>
        <option name="charting.axisY2.scale">inherit</option>
        <option name="charting.chart">line</option>
        <option name="charting.chart.bubbleMaximumSize">50</option>
        <option name="charting.chart.bubbleMinimumSize">10</option>
        <option name="charting.chart.bubbleSizeBy">area</option>
        <option name="charting.chart.nullValueMode">gaps</option>
        <option name="charting.chart.showDataLabels">none</option>
        <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
        <option name="charting.chart.stackMode">default</option>
        <option name="charting.chart.style">shiny</option>
        <option name="charting.drilldown">all</option>
        <option name="charting.layout.splitSeries">0</option>
        <option name="charting.layout.splitSeries.allowIndependentYRanges">0</option>
        <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
        <option name="charting.legend.placement">right</option>
      </chart>
    </panel>
  </row>
  <row>
    <panel>
      <title>DHCP Thresholds</title>
    </panel>
  </row>
  <row>
    <panel>
      <single>
        <title>Max LPS</title>
        <search>
          <query>index=* |head 1| eval max=$lps_threshold$|table max</query>
          <earliest>0</earliest>
          <latest></latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">none</option>
        <option name="numberPrecision">0</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="useColors">0</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="drilldown">none</option>
      </single>
    </panel>
    <panel>
      <single>
        <title>LPS Threshold Prediction</title>
        <search>
          <query>index=ib_dhcp_summary report=si_dhcp_message                (orig_host="$grid_member_var$")                | stats      sum(v4ack) as v4ack by _time                | timechart bins=1000  avg(v4ack) as "Leases"                | interpolate 1200                * |eval Leases=Leases/86400 |emm Leases| predict emm future_timespan=90 as prediction        |where prediction&gt;=$lps_threshold$              | sort _time              | head 1              | eval month_year=strftime(_time,"%B %d %Y")              |table month_year</query>
          <earliest>-1y</earliest>
          <latest>now</latest>
        </search>
        <option name="colorBy">value</option>
        <option name="colorMode">none</option>
        <option name="numberPrecision">0</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="useColors">0</option>
        <option name="useThousandSeparators">1</option>
        <option name="linkView">search</option>
        <option name="drilldown">none</option>
      </single>
    </panel>
  </row>
  <row>
    <panel>
      <chart>
        <title>LPM Prediction</title>
        <search>
          <query>index=ib_dhcp_summary report=si_dhcp_message                (orig_host="$grid_member_var$")                | stats      sum(v4ack) as v4ack by _time                | timechart bins=1000  avg(v4ack) as "Leases"                | interpolate 1200                * |eval Leases=Leases/86400 |emm Leases| predict emm future_timespan=90 as prediction | eval Max_QPS=$lps_threshold$</query>
          <earliest>-1y</earliest>
          <latest>now</latest>
        </search>
        <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
        <option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option>
        <option name="charting.axisTitleX.visibility">visible</option>
        <option name="charting.axisTitleY.visibility">visible</option>
        <option name="charting.axisTitleY2.visibility">visible</option>
        <option name="charting.axisX.scale">linear</option>
        <option name="charting.axisY.scale">linear</option>
        <option name="charting.axisY2.enabled">0</option>
        <option name="charting.axisY2.scale">inherit</option>
        <option name="charting.chart">line</option>
        <option name="charting.chart.bubbleMaximumSize">50</option>
        <option name="charting.chart.bubbleMinimumSize">10</option>
        <option name="charting.chart.bubbleSizeBy">area</option>
        <option name="charting.chart.nullValueMode">gaps</option>
        <option name="charting.chart.showDataLabels">none</option>
        <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
        <option name="charting.chart.stackMode">default</option>
        <option name="charting.chart.style">shiny</option>
        <option name="charting.drilldown">all</option>
        <option name="charting.layout.splitSeries">0</option>
        <option name="charting.layout.splitSeries.allowIndependentYRanges">0</option>
        <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
        <option name="charting.legend.placement">right</option>
      </chart>
    </panel>
  </row>
</form>

[#2]

is there a way to change this to key in on a different source for the 'member' drop down?

I don't run DNS In my grid yet so it doesn't populate anything.  I'm not really interested in QPS but LPS would be an interesting one to see.

[#3]

What version of NIOS are you running? As of 8.0 this report was rolled into the product and it does QPS, LPS, CPU, and various other metrics.

[#4]

I'm on 8.0.6....what's it named now that it's rolled in?

[#5]

System Capacity Prediction Trend

[#6]

Hi,

I am interested in running System Capacity Predication Trend.

But for the CPU threhold Predication --> I get N/A

and in DB objects treshold predication --> I get N/A with an error: command="predict", Too few data points: 0. Need at least 2

The same with QPS and LPS

Does anyone know the cause of this?

BR
Mena

[#7]

What version of NIOS are you running? Do the previous comments in this thread apply to you?

-Roger

[#8]

Hello RBarlow,

i'am wondering if its possible to get a "IB-V1415" in to your Dashboard at "select member type"?

Do you have a hint for me? We are running NIOS 8.5...

best, webera