4 Replies Latest reply on Nov 6, 2012 8:23 AM by James Golden

    Two server configuration for improving performance?

    James Golden

      Hi folks,


      We are looking to add another machine to our configuration for having two servers for Tableau.  We are currently running one machine, a Windows 16bit, with 4 cores and 16.0 GB RAM.


      We are going to be setting up our system on VM; and will be introducing a new machine as a worker server.


      We will using mostly extracts, that will run in off hours for approximately 90% of our processes.


      What we are considering is moving all the background processes off to the worker machine; but we are still evaluating.


      We currently have processes set as 1 repository, 1 data engine, 2 server web app, 4 VizQL, 2 data server, and 5 background tasks.


      Can anyone recommend a successful configuration similar to what we are looking to accomplish?




        • 1. Re: Two server configuration for improving performance?
          James Golden

          Does anyone have a recommendation for the processes distributed between the two machines?  Background?  Repository?  Thanks

          • 2. Re: Two server configuration for improving performance?
            Russell Christopher

            Hi James -


            I suspect the reason you haven 't gotten a reply is because the answer really is "it depends", and folks (myself included) don't want to give you a one-size-fits all answer that doesn't fit your particular situation. There are a number of different variables in play, and it'd be pretty difficult to work through everything via a forum posting.

            That being said, here are some thoughts. I think you'll probably need to experiment a little to find the settings that work best for you, however.


            • 4 VizQLs on a machine that only has 16 GB of RAM sounds a bit too much to me - The VizQLs could consume all the RAM on the machine, without leaving anything left for the OS or other Tableau processes. Too many VizQLs will also bring down your Cache Hit ratio which results in lower "perceived performance" ffor your users. Consider lowering this to 2 unless you have a specific reason why set it at 4.
            • I like the idea of putting your backgrounders on a distinct machine. The Data Engine is also resource intensive process, so you might might want to consider putting it on the same box as the Backgrounders, too. Since your extract refreshing work will happen at night, that leaves the Data Engine with lots of room during the day to do it's work.



            Hope this helps?

            1 of 1 people found this helpful
            • 3. Re: Two server configuration for improving performance?
              James Golden

              Thank you Russell,


              I think we'll split the VizQL to 2 and 2 between the machines, drop the Data Engine to the worker, and put our background processes on the worker.  I think we'll start with 4.


              I appreciate it,


              • 4. Re: Two server configuration for improving performance?
                James Golden

                BTW - I meant we are on a 64 bit system.