top of page

Tableau Performance Recording

Author: Mansi Anand


If you are caught brainstorming, what is inflicting the overall performance of your workbook to sluggish down?


Don't worry! The Performance Recording feature in tableau records the performance information about key events as you interact with the workbook and keep you covered in improving the performance.


What is Performance Recording?

Performance recording is used to examine and troubleshoot events that would have an effect on the overall performance of your dashboards, inclusive of query execution, connection to data sources, layout computations, extract generation, blending records, etc.


How can I do Performance Recording?

For Tableau desktop -> You can document the overall performance of your dashboard via way of means of going to.


Help Menu >> Setting and Performance >> Start Performance Recording


snippet showing "Start Performance Recording" feature in tableau desktop

Now that the recording has started, move and engage together along with your dashboard/workbook as events are being recorded.


Once you're through, you could stop overall performance recording via way of means of going to


Help menu >> Setting and Performance >> Stop Performance Recording.


snippet showing "Stop Performance Recording" feature in tableau desktop

Wait for some seconds, and the overall performance recording workbook will pop up. You'll see a dashboard via the means of the title "Performance Summary."


This Performance recording workbook includes essential dashboards, particularly Performance Summaries and Detailed views.


snippet of "performance recording" workbook

Performance Summary: The overall performance summary presents an excessive degree assessment of the maximum time-eating events.


The Performance Summary dashboard includes 3 perspectives: Timeline, Events, and Query.


Timeline

The uppermost view within the overall performance summary recording dashboard suggests the events that took place in the course of recording, organized chronologically from left to right. The bottom axis suggests elapsed time since Tableau started in seconds.


In the Timeline view, the Workbook, Dashboard, and Worksheet columns discover the context for events. The Event column identifies the nature of the event, and the very last column suggests every event's duration and the way it compares chronologically to different recorded events.


snippet of "timeline" in performance summary dashboard
Events

The center view in an overall performance summary dashboard suggests the events, sorted by way of means of the time period (finest to least). Events with longer intervals will let you discover in which appearance first you need to speed up your workbook.


snippet of "event" in performance summary
Query

If you click on an Executing Query event in both the Timeline or Events section of an overall performance summary dashboard, the text for that query is displayed withinside the Query section.


If you're related to a published data source, the query text is displayed in XML. If you're related to the data source directly, the query is displayed in SQL like, shown below:


snippet of "query" displayed in sql

Sometimes the query is truncated, and you will want to appear with-inside the Tableau log to discover the whole query. Techniques like developing Indexes may be used to optimize the query’s overall performance, and for enhancing efficiency, Tableau permits you to combine more than one query right into a single query in opposition to the data.


Detailed View:

While the detail views offer loads greater detail to be utilized by superior users when constructing dashboards


Depth:

The Depth view is the uppermost view withinside the Detailed Views dashboard and presents insight into what occurs when a request is made. This view is the most beneficial when filtered to a single user request. Examples of user requests are: loading a view, choosing a mark, or changing a filter.


Each bar on the depth view represents a single activity. An activity is a unit of work that is carried out as a part of processing a user request. A single user request results in more than one activities


snippet of "depth view" under detailed view dashboard
CPU and Elapsed Time

The CPU and Elapsed Time views appear lowermost with-inside the Detailed Views dashboard. You can toggle between Exclusive CPU, Inclusive CPU, and Elapsed Time views via means of clicking on the radio buttons.



The Exclusive CPU, Inclusive CPU, and Elapsed Time views offer aggregate statistics for every activity. The number of times an activity took place is shown with-inside the Count column, and the overall quantity of time taken via the means of a single activity is shown using the bar chart.


Conclusion:

Performance recording is available whilst the fine-tuning overall performance of workbooks empowers developers to identify and correct events taking a long-time.


References:

Record and Analyze Workbook Performance - Tableau


22 views0 comments

Recent Posts

See All
bottom of page