In this section:
The DataServer workbook can be used to visualize information contained in the DataServer process Java and C++ logs. DataServer processes come into play when using published datasources. If your Tableau Server installation has published datasources this workbook can be used to provide operational insight into the DataServer processes.
Glossary of Important Terms to Understand DataServer Workbook Data and Dashboards
The ART workbook (link to ART workbook guide page) can help narrow down on performance bottlenecks through flamecharts. However, when published datasources are used, the ART flamecharts will only highlight slow ‘sqlproxy’ queries or slow ‘sqlproxy’ connections. It will be unable to provide further details regarding the slowness. Using the DataServer workbook, the user can see details of all the dataserver requests that were issued for that client request. This can help further narrow down the area of slowness within dataserver.
This dashboard is very similar to the Intermittent Slow queries dashboard from the ART workbook (link to ART workbook guide page).
For published datasources, the dashboard will highlight intermittent database performance for the underlying database.
This dashboard shows elapsed times for all queries and connection requests from DataServer. Each mark in the top Query Elapsed Times view (see below) corresponds to a single query issued by DataServer against the underlying database. Each mark in the bottom Protocol Creation Times view corresponds to a single protocol creation (i.e. connection to a database) request from DataServer.
You can use this dashboard to easily identify slow protocol creation and slow queries for a specific database type.
This view provides information on how much of the DataServer load is driven by requests from vizqlserver (view loads) v/s backgrounder (extract refreshes, subscriptions, data driven alerts).
This view breaks down DataServer queries by category.
Using the ART workbook, the user can copy the client (vizqlserver) request ID and enter it in the top right ‘Client Request Id’ box. The top view in this dashboard then lists out all the dataserver requests issued as part of that client request. Each row in the top view corresponds to a single dataserver request. Clicking on any row then shows a timeline of all log messages corresponding to that dataserver request, from both the Java and C++ logs.
This view is like the ‘Timeline – Client Req ID’ view; but is based on the user provided dataserver request ID. If the user wants to dig into a specific dataserver request ID and get the timeline, then this view can be used.