Monitoring and Tunning Query Performance

Monitoring and Tuning Query Performance involves regularly analyzing query execution times, identifying bottlenecks, and collaborating with Kyvos administrators to optimize both Tableau workbooks and Kyvos semantic models. Performance monitoring reveals patterns in slow queries, inefficient visualizations, and opportunities for semantic model optimization. Tableau's Performance Recording provides detailed query execution timelines, while Kyvos query logs display the performance of the semantic model. Regular performance analysis ensures optimal user experience and helps prevent performance degradation as data volumes grow or user adoption increases.

To monitor and tune query performance, perform the following steps.

1. Open the Tableau Dashboard.

2. Go to Help menu > Settings and Performance > Start Performance Recording.

   Open

   

3. Run the dashboard, apply action filters, adjust parameters as needed, and then stop performance recording. Tableau will generate a performance recording dashboard automatically.

   Open

   

4. In the performance workbook, go to the "Timeline" sheet. Identify the longest-running queries, typically represented by red or orange bars, and hover over or click the bar for more information. You can see the query details and the time taken to run.

   Open

   

5. Look for patterns: specific filters, dimensions, or measures causing slowness.

6. Contact Kyvos administrators to review problematic queries. Discuss opportunities for semantic model optimization, including new aggregations and better partitioning.

7. After Kyvos optimizations are deployed, re-test the same workflows.

8. Use Performance Recording to measure improvement.