Here is the batch file I created and I was able to set this on task scheduler to clean daily.

Also there is a fix for this issue in the 9.0.3 release but I have already found a bug in that release for parallel queries in live reports using multiple data sources and tables.

batch file:

cd C:\Program Files\Tableau\Tableau Server\9.0\bin

tabadmin cleanup

Hello Donna,

A)  The issue I was experiencing in 9.0.1 was that the size of my hard drive would become significantly lower every day. For example on Monday the free space would be about 68gb, the next day 62gb, wednesday 50gb, and when we returned on the next Monday people were having the issue of Tableau Server no longer working.

I checked the server and disk space was full. After further research, Tableau Server would stop responding and need to be restarted due to an excess of INFO messages being written to the zookeeper log file. This is now in the release notes for Tableau 9.0.3 which has now been fixed.

See: http://www.tableau.com/support/releases/9.0.3#Tableau-Server

B) The issue I found in 9.0.3 is still being researched by the Tableau Development team. They have come up with a work around to solve the issue which I will send you the cmd script for in case you experience the same issue. We have a live report that accesses information changing at least one time per minute. This report pulls for 5 different data sources from various different tables. When we upgraded to 9.0.1 the report completely stopped working and had to be rebuilt. After rebuilding the users of this report were frequently not able to see the report and received error messages.

The error messages were due to a problem with parallel queries running at the same time. (This is a new feature in Tableau 9 that is supposed to speed up performance.)

The development team thought the problem would be fixed by upgrading to 9.0.3 but this was not the case.

We solved the issue temporarily by disabling the parallel queries feature which is new to Tableau 9.

Here is the cmd script to disable parallel queries for Tableau server 9:

- tabadmin stop

- tabadmin set native_api.connection.limit.sqlserver 1

- tabadmin config tabadmin start

Here is the cmd script to re-enable parallel queries if the problem is solved:

- tabadmin stop

- tabadmin set native_api.connection.limit.sqlserver -d

- tabadmin config tabadmin start

Hope this helps!

Connor Singerline