4 Replies Latest reply on Sep 11, 2019 5:35 AM by Rohit Babber

    Tableau Server Hardware Structure Enhancement

    Rohit Babber

      We are working to analyze the hardware structure for or tableau server.

       

      We have 16 physical CPU cores licenses and are going to increase the capacity by 16 more physical CPU cores which equates to total 32 cores.

       

      Current modal have 1 primary machine with gateway process and two 8 physical CPU cores nodes(Worker 1 and Worker 2) having all the licensed processes with Active and Passive repository on it.

       

      Now we have to plan for another new 16 cores. So we have below scenarios for planning.

       

      1, Either Worker 1 and Worker 2 we can enhance to 16 physical CPU cores each so by this we will remain on 3 node structure.

      2. Or Setup a new worker 3 node of total 16 physical CPU cores.

      3. Or setup 2 new workers 3 and 4 of total 8 CPU cores each.

      4. Or enhance Worker 1 and Worker 2 to 12 physical CPU cores and setup new worker 3 with 8 CPU cores.

       

      Our organization have equal kind of distribution for Interactive users and with good amount of backgrounder processes as well.

      So what could be a best structure for us. Also please note we are going to acquire 4 CPU cores data prep conductor key as well.

       

      Note: Hardware machines we have for  worker nodes those are 20 physical CPU core machines, so for running 8 CPU core licenses our windows team has disabled rest of 12 physical CPU cores.

       

      Thanks,

      Rohit

        • 1. Re: Tableau Server Hardware Structure Enhancement
          Michael Gillespie

          What problem(s) are you trying to solve by adding more cores to this environment?  Are your extracts slow?  Do your users report long load times for dashboards?

           

          Different problems have different solutions - can you describe those problems?

           

          How many users do you have?  How many extract refreshes?  How often and when do those refreshes run?  These, and more, are the kinds of questions you should be asking before you determine if you need to increase the available hardware resources in your environment.

          • 2. Re: Tableau Server Hardware Structure Enhancement
            Chris McClellan

            I agree with Michael, I would be doing a LOT more analysis on what is actually wrong before you purchase more licensing.  By doing this analysis properly you know how many more core licenses you will need AND you will know exactly how to configure them as well.

             

            Rohit Babber wrote:

             

             

            Note: Hardware machines we have for worker nodes those are 20 physical CPU core machines, so for running 8 CPU core licenses our windows team has disabled rest of 12 physical CPU cores.

             

             

            That sounds just a little bit backwards , maybe just a waste of resources .... unless a 20 core machine is cheaper than an 8 core machine ?   

            • 3. Re: Tableau Server Hardware Structure Enhancement
              Rohit Babber

              Hi Michael,

               

              Below are the answers to the questions.

               

              We have around 15k users who visited our tableau server in last 6 months. The count for just last 7 days is 3500 Active users.

               

              We have around 3200 Full extract and Incremental data extracts total running every day. These are distributed in complete 24 hours. On avg. 138 data extracts are running every single hour by our backgrounders. 95% jobs are able to complete within 5 minutes.

               

              For Current server architecture and Load times for views please refer the attached MS Word file.

               

              Thanks,

              Rohit

              • 4. Re: Tableau Server Hardware Structure Enhancement
                Rohit Babber

                Hi Chris,

                 

                About below Note

                Note: Hardware machines we have for worker nodes those are 20 physical CPU core machines, so for running 8 CPU core licenses our windows team has disabled rest of 12 physical CPU cores.

                 

                This is something standard in our organization when we request for a hardware machine they allocate a machine having 20 CPU cores and 192 GB Ram.

                We have virtual machines as well and there are 3 standards as well. If we request them a VM with custom configuration that is something going to be much costlier.

                 

                I really want to use our CPU cores so looking for some best recommendation of structure.

                 

                Thanks,

                Rohit