Record and analyze workbook performance?

Record and analyze workbook performance

Record and analyze workbook performance?

EXPLANATION
Your workbook is done and you’re wondering if its performance is taking a little longer than it should. To find out what’s slowing it down, you can use a performance recording to evaluate your workbook. This is an especially good idea if you plan to share or publish the workbook.

The Performance Recording feature in Tableau records performance information about key events as you interact with a workbook. You can then view performance metrics in a workbook that Tableau creates to analyze and troubleshoot different events that are known to affect performance:

Query execution

Geocoding

Connections to data sources

Layout computations

Extract generation

Blending data

Server blending (Tableau Server only)

Tableau support may ask that you create a performance workbook as they work with you to diagnose performance issues.

Create a performance recording in Tableau Desktop
To start recording performance, follow this step:

Help > Settings and Performance > Start Performance Recording

To stop recording, and then view a temporary workbook containing results from the recording session, follow this step:

Help > Settings and Performance > Stop Performance Recording

You can now view the performance workbook and begin your analysis.

If you are sending the recording to Tableau Support, save this workbook as a packaged workbook (.twbx) file, and then send it.

Interpret a performance recording workbook
A performance recording workbook is a Tableau dashboard that contains three views: Timeline, Events, and Query.

Timeline
The uppermost view in a performance recording dashboard shows the events that occurred during recording, arranged chronologically from left to right. The bottom axis shows elapsed time since Tableau started, in seconds.

In the Timeline view, the Workbook, Dashboard, and Worksheet columns identify the context for events. The Event column identifies the nature of the event, and the final column shows each event’s duration and how it compares chronologically to other recorded events:

Record and analyze workbook performance

Events

The middle view in a performance recording workbook shows the events, sorted by duration (greatest to least). Events with longer durations can help you identify where to look first if you want to speed up your workbook.

Record and analyze workbook performance

Different colors indicate different types of events. The range of events that can be recorded is:

Computing layouts

If layouts are taking too long, consider simplifying your workbook.

Connecting to data source

Slow connections could be due to network issues or issues with the database server.

Executing query

For live connections, if queries are taking too long, it could be because the underlying data structure isn’t optimized for Tableau. Consult your database server’s documentation. As an alternative, consider using an extract to speed performance.

For extracts, if queries are taking too long, review your use of filters. If you have a lot of filters, would a context filter make more sense? If you have a dashboard that uses filters, consider using action filters, which can help with performance.

Generating extract

To speed up extract generation, consider only importing some data from the original data source. For example, you can filter on specific data fields, or create a sample based on a specified number of rows or percentage of the data.

Geocoding

To speed up geocoding performance, try using less data or filtering out data.

Blending data

To speed up data blending, try using less data or filtering out data.

Server rendering

You can speed up server rendering by running additional VizQL Server processes on additional machines.

Leave a Reply

Your email address will not be published. Required fields are marked *