- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
System Predictive Dashboard
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-04-2016 01:05 PM - edited 02-04-2016 01:08 PM
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>=$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>=$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>
Re: System Predictive Dashboard
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-12-2017 08:19 AM
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.
Re: System Predictive Dashboard
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-12-2017 09:17 AM
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.
Re: System Predictive Dashboard
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-16-2017 07:33 AM
I'm on 8.0.6....what's it named now that it's rolled in?
Re: System Predictive Dashboard
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-16-2017 11:28 AM
System Capacity Prediction Trend
Re: System Predictive Dashboard
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-10-2017 06:28 AM
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
Re: System Predictive Dashboard
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-10-2017 09:38 AM
What version of NIOS are you running? Do the previous comments in this thread apply to you?
-Roger
Re: System Predictive Dashboard
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-28-2020 05:14 AM - edited 02-28-2020 05:19 AM
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