Tableau - Extract Size on Disk 100x Larger than Stats for Space Usage Admin Viz Shows

0 votes

I was going to update from 10.4 to 10.5.3 when I noticed that the HDD on which Tableau was installed was nearly full - 115GB out of 127GB had been consumed. I ran tabadmin cleaning and it's currently at 110GB.

I looked to check what was using up the space and saw that "T:Program FilesTableauTableau Serverdatatabsvcdataengineextract" was taking over 100GB. All datasource extracts total roughly 900MB, according to the "Stats for Space Usage" across all sites. Adding certain workbooks that have been saved as.TWBX files since the total size of all sites is less than 1GB.

Please explain the reason for this disparity.
What is taking up this space?
What's the best way for me to reclaim this space?

I was going to update from 10.4 to 10.5.3 when I noticed that the HDD on which Tableau was installed was nearly full - 115GB out of 127GB had been consumed. I ran tabadmin cleaning and it's currently at 110GB.


I looked to check what was using up the space and saw that "T:Program FilesTableauTableau Serverdatatabsvcdataengineextract" was taking over 100GB. All datasource extracts total roughly 900MB, according to the "Stats for Space Usage" across all sites. Adding certain workbooks that have been saved as.TWBX files since the total size of all sites is less than 1GB.

Please explain the reason for this disparity.

What is taking up this space?

What's the best way for me to reclaim this space?

I'm deferring my upgrading till I have enough room to ensure that it doesn't fail. I'm also worried about the server crashing if it runs out of space - I'm pleased I noticed this problem early!!

I used the following commands after the first tabadmin cleaning, but they didn't help:

  1. tabadmin cleanup
  2. tabadmin stop
  3. tabadmin clearcache
  4. tabadmin cleanup
  5. tabadmin start

Mar 17 in Tableau by Vaani
• 5,040 points
34 views

1 answer to this question.

0 votes
This might be due to a variety of factors –

1. All log files are erased from Tableau Server when you execute tabadmin cleanup while it is stopped

ProgramData\Tableau\Tableau Server\data\tabsvc\logs

but not from

ProgramData\Tableau\Tableau Server\logs

2. It's possible that the backup created during the update took up some space. They frequently take up a significant amount of space. (I believe this is the problem)

3. Try searching with .tsbak in Tableau folder

EDIT:

When you run tabadmin cleanup whilst running Tableau Server

4. Active logs and log files from ProgramData\Tableau\Tableau Server\logs are not removed.

5. Temporary files are not removed.

6. Files that are in use (that is, locked by the operating system) are not removed.
answered Mar 22 by Neha
• 6,260 points

Related Questions In Tableau

0 votes
1 answer
0 votes
0 answers

Tableau layout for multiple charts on one worksheet

On one spreadsheet, I have 15 pie ...READ MORE

Mar 10 in Tableau by Neha
• 6,260 points
24 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,230 points
7,949 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
48 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
66 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
34 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
71 views
0 votes
1 answer
0 votes
1 answer

Tableau: List Projects > Workbooks > Views for an authenticated user

I recently utilised the Tableau Rest API ...READ MORE

answered Mar 10 in Tableau by Neha
• 6,260 points
26 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP