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
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.
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.
Performance Summary: The overall performance summary presents an excessive degree assessment of the maximum time-eating events.
The Performance Summary dashboard includes three 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 the 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.
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.
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, shown below:
Sometimes the query is truncated, and you will want to appear with-inside the Tableau logs 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
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