The Tableau Server 9 admin views are a massive improvement on those of Tableau 8.
Also, Tableau has made the Tableau Server admin view workbook publically available, http://community.tableau.com/thread/162348, which, in case it disappears for some reason, is also attached to the bottom of this post.
Previously I wrote a post about creating your own Tableau Server admin views which were based on my need to monitor report usage.
Customise Monitoring Background Tasks on Tableau Server
I use the Tableau Server admin views for monitoring the background tasks.
Whenever I’m in an ‘extract heavy’ environment it’s very important to keep an eye on how the Tableau extracts are updating.
The default Tableau Background Tasks view is ok. However, as Tableau has made the workbook public, it’s very straightforward to modify the view ‘Background Tasks for Extracts’.
The modifications give more visibility into the extract processes.
One thing missing is the time the extract actually started to refresh. I understand it’s in there, however, the default admin view on Tableau Server 9 shows the time the extract refresh entered the queue.
I also want to see the time it started to update.
A few minor alterations and the ‘Background Tasks for Extracts’ includes both the queue entry time and the refresh start time.
Make these changes to enhance Tableau background task monitoring
1. Go to the worksheet ‘What Extracts Have Run in the past 24 hours?’ in the ‘Background Tasks for Extracts’ dashboard.
2. Drag the dimension [started_at_local] to the columns shelf, on top of the existing [created_at_local], replacing the [created_at_local] field. Set it to Exact Date and Continuous.
3. The size of the gantt bar also needs altering. Edit the measure [runtime_sec_gant]. We want to calculate the difference between the start and completed at time. Change the formula to:
DATEDIFF('second',[started_at_local],[completed_at_local_nonull])/(60 * 60 * 24)
4. Now the “queue entry” time ([created_at_local]) has gone from the view. I still want to see it so will bring it back in the form of a reference line. Drag the dimension [created_at_local] to the ‘All’ Marks Detail shelf setting it to Exact Date and Continuous
5. Right click on the X axis to add a Reference Line and select the value [created_at_local]. This should be a Line – Per Pane reference line. Personally I remove the label and also remove the fill. Leaving it at the default Minimum is fine.
Once complete the worksheet should now look something like this, with the altered fields crudely circled:
The original file is zipped up here: Server Admin Views 9.0.twb