2 Replies Latest reply on Feb 11, 2019 4:25 AM by Anatoliy Sulin

    Wild sag of productivity

    Anatoliy Sulin

      Question.

      We have a Tableau 2018.1.6 server.

      The server behaves is unpredictable.

      We disconnected all schedules. Users of reports of access to the server have no. If to take any report even on extract. To measure the speed of its work. The field of the restrat of a system, on average the report works 1 second. Then for the night to do load through TabJolt of the server according to any reports. For the morning productivity of the report falls in tens of times. Even the pretty report on extracts weighing less than 1 megabyte, begins to work 30  seconds though worked 1 second in the evening. What can such sag of productivity be connected with? On resources of everything is enough. Always it is more than 100 gigabytes of free random access memory. CPU Xeon 6142 Cores 32. Utilization at most no more than 30%. Tried the disks SSD did not help. We cannot understand why such wild sag of productivity.

        • 1. Re: Wild sag of productivity
          Mihai Constantinescu

          There are various possible reasons ... you could raise it with Tableau Support and maybe they can go through your logs. There are some questions you might want to check:

          1. Do you have anything else running on your Tableau server box? any other processes that might be running during morning, Go through your logs and check any memory/cpu spikes etc (what is the time range, whole morning?)? Do you have more slaves?

          2. Network bandwidth, can you test if you have decreased performance on your network during that time and how is the Tableau Server/ Tab Desktop communicating with the database / can you check the users's connectivity to the server, are there any VIPs, proxy issues etc

          3. Is this happening on Tableau desktop or only server?

          4. You can also try to use the Tableau Desktop Performance Analyser and see if it's giving you a better insight

          5. Do you have any re-occuring Tableau reboots?

          6. How is your caching configured on your server (more or less frequent)?

           

          etc ...

          • 2. Re: Wild sag of productivity
            Anatoliy Sulin

            In support Case Number 04539540 so far of the help addressed is not present.

            1. On the server except Tableau there is nothing. It is created especially for this test.

            2. We check reports postorenny for extraxt to iskolyuchit network problems.

            3. Occurs on Tableau Sever 2018.1.6 After several hours of loading of TabJolt

            4. Noticed that in the morning on a tomzha the report, Bilding View is increased

            5. We do not overload the server. As reset helps, but it is not an exit for industrial service

            6. Refresh less often

             

             

            With switched off by shedulers there is a record on a disk in the C:\ProgramData\Tableau\Tableau Server\data\tabsvc\temp folders. Maybe is not enough what resource. For example now random access memory it is free 77Gb from 512Gb