Tableau Server how to check the performance using Performance Monitor and Repository data

Part 1. Collect data with Windows Performance Monitor

Step 1.

1. Open Performance Monitor with Run as Administrator
2. in the left pane, click Data Collector Sets.
3. In the right Pane, right-click User Defined -> NEW -> Data Collector Set.
4. In the Create new Data Collector Set, enter a name.
5. Select Create manually(Advanced).
7. Under Create data logs, select Performance counter, and click Next.

Step 2.

1. set the sample interval to 30 seconds and Add.
2. Select Performance counter from below list.

- Logical Disk 

Current Disk Queue Length
Disk Read Bytes/sec
Disk Write Bytes/sec

- Memory

% Committed Bytes in Use
Available Mbytes

- Process :select counter for below process

• % Processor Time
• Private Bytes

for below process

• Total
• hyperd (Data engine)
• redis-server (Cache server)
• run-backgrounder (Backgrounder)
• run-dataserver (Data server)
• run-vizqlserver (VizQL Server)

- Processor Information

%Processor Time
% Processor Utility





Step 3.

1. Finish
2. In the left pane of the main Performance Monitor, select the data collector set created above.
3. In the right pane right-click the performance counter DataCollector01 and click Properties.
4. Select Comma separated and click ok






Part 2. Enable access to Tableau Server Repository

Step 1. Verify Tableau Server PgSQL port and listening.

By default, it is set as 8060.






2. run below command on CMD to enable repository access.


tsm data-access repository-access enable --repository-username readonly --repository-password pass1234

This will restart Tableau Server

3. Confirm the data-access
tsm data-access repository-access list





Part 3. Analyze with sample workbook

1. Download sampleworkbook

Link:
https://help.tableau.com/current/server/en-us/perf_analyze_sample_workbook.htm

2.
- Edit connection of Resource Usage to the collected data
- Edit connection of other data source to Tableau Server

3. Remove date filter from the extract in data source connection
4. Move to CPU usage dashboard and go to CPU sheets
5. Replace Reference all PerMon fields with exclamation mark with new one.
6. Check filter in each sheet if no data is showing.

<<Youtube Demo>>