These particular workbooks will exist as a community effort, however at Tableau we are always proudly “eating our own dog food” and have been diligently applying similar workbooks to our own servers – using Tableau on Tableau. Ultimately we hope to provide customers with tools and metrics that will allow you to increase the efficiency of your BI services and make proactive decisions concerning your BI roadmap.
These workbooks will help answer the most common questions you may have about your sever, but my wish is for them to be living, organic entities that can be taken apart, repurposed, and improved upon by anyone; therefore I have exposed every join, every table, and every calculated field I used so that you may learn, play, and experiment to your heart’s content.
- Server Sizing Monitor– Dashboards to track background tasks, http requests and actions, server load, and Vizql Sessions.
- Data Connections and Permissions– Dashboards to track user permissions and data connections, including which extracts share the same data connections, and what workbooks connect to which published data sources.
- View Traffic Monitor– The most popular views on the server, the most active users, and most active days for viewership. This Dashboard tracks and ranks incoming traffic to the server.
- Extract Error Monitor– Dashboards to identify extract errors and error types, extract refresh/increment duration, and error messages.
- Subscriptions Timer– Dashboards to track late subscription emails for workbooks and views.
Instructions can be found here
Together these workbooks will allow you to not only audit your server, but to discover new insights and explore server operations and usage.
You will need Tableau Desktop installed and have full access to your Tableau Server db to access these workbooks in their entirety; I would advise following the steps in the DAAP documentation.
With the release of 8.2.5, Tableau introduced the read-only user, offering customers a new world of possibilities for monitoring the status and performance of Tableau Server. While the information in the Postgres tables available to the base “Tableau user” was already vast, the tide of information now unleashed with 8.2.5 will allow for insights never before possible. In the past we have provided instructions for how to use the Postgres tables to create custom admin views to monitor your system, with the read-only user, we made this process easier than ever.