Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

DISK IO

stuartpollicott
6 - Meteoroid

No one ever mentions DISK IO requirements, just size.

 

I have an Alteryx Server and want to add some more storage, can I do this via CIFS, or should it be direct attached or should it even be SSD?

 

What guidance is there around DISK IO and different workloads?  I can only find the Technical Overview as per;

http://downloads.alteryx.com/Documentation/Alteryx%20Technical%20Overview.pdf

 

Which in section " Performance and Scaling Considerations " mentions maybe needing SSD for CASS, Calgary, and geocoding functions.

 

Any help or experiences welcome.

4 REPLIES 4
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

@stuartpollicott it probably isn't mentioned due to the wide variety of uses, all with varying requirements.

In my experience though, you will want to use SSD.

I'm working on some more recommendations to post at a later time.

stuartpollicott
6 - Meteoroid

Any further findings would be very useful.  Basically though as my engineering team are trying to see if an Isilon Share will suffice, I should assume NOT and as a minimum go for SAN attached SATA or more ideally use SAN Attached SSD.

MarqueeCrew
20 - Arcturus
20 - Arcturus

Your working disk should be attached SSD.  I've seen issues with network storage with high volume I/O where Alteryx is writing too fast and timeout issues have happened.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

I have yet to see a *great* server experience on anything other than SSD.  It might be possible, but I doubt it.

I would stay away from an Isilon Share.  SAN attached SATA would provide a moderately "okay" experience.

The Alteryx engine heavily utilizes I/O resources.  The faster hardware it has to work with (reading, writing, transferring data), the better it performs.