Prediction tool for identifying server failure

[susukavi]

Hi Team,

I am trying to predict the server failures in future,based on past historical data.Kindly suggest me which predictive tool can be used to get most desired output.Below is the sample record.Whenever CPUbusy crosses 70%,we are considering that as failure.Need to find when we may get failures

date hostname cpubusy
1/6/2020 test1 0.756
1/7/2020 test1 0.456
1/8/2020 test1 0.667
1/9/2020 test1 0.876

[PhilippK]

Hello @susukavi ,

in this case you want to predict "cpubusy", which is numeric. Therefore you need an algorithm for a Regression problem: 

You can find example workflows here:

In addition, I recommend our Data Science Learning Path for you, to learn more about it:
https://community.alteryx.com/t5/Learning-Paths/Data-Science-Learning-Path/ta-p/504157

Alternatively, you can leverage the Alteryx Designer Add-On "Intelligent Suite". With its "Assisted Modeling", you get a guide along your way to build a predictive model.

Let me know whether this is the solution you were looking for.

Best regards

Phil 

[susukavi]

Hi Phillip,

Here i am trying to find future dates when the server will fail,based on past data.

Whic tool will be more appropriate for this use case.

[RolandSchubert]

Hi @susukavi ,

it seems, you want to use only historical data to predict server failures in the future, i.e. your assumption is, that there is some kind of "seasonality" in server temperature. You could try to use one of the Time Series tools to predict the fluctuations of temperature and filter the predicted results for values indicating a failure. 

What do you think?

Best,

Roland

[PhilippK]

Hi @susukavi ,

yes, in this case the time series tools are indeed a better fit, as Roland mentioned.

Here you can find sample workflows:

and here you can learn more about it:

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Time%20Ser...

Let me know whether this helps you.

Best regards

Phil

[susukavi]

@phillip  I have gone through time series tools. can you please help me in creating simple workflow with timeseries tool for my requirement...Thanks in advance.

[PhilippK · Accepted solution]

Hi @susukavi ,

no worries, it's quite advanced. I can understand that you need more support on that.

Luckily, you can leverage our "Virtual Solution Center" - here you can book a session with an Alteryx Expert free-of-charge:
https://community.alteryx.com/t5/Virtual-Solution-Center/tkb-p/vsc
(click on the chat bot)

 

Best regards

Phil