Skip to main content

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>>




Comments

Post a Comment

Popular posts from this blog

How to configure LDAPS, LDAP over SSL, using CA Certificate Service on Domain Controller in Windows Server 2016

This post is to provide an instruction on how to set up LDAPS (LDAP over SSL) on Domain Controller using single-tier CA hierachy. Reasons for Enabling LDAPS By default, LDAP communications between client and server applications are not encrypted. This means that it would be possible to use a network monitoring device or software and view the communications traveling between LDAP client and server computers. This is especially problematic when an LDAP simple bind is used because credentials (username and password) is passed over the network unencrypted. This could quickly lead to the compromise of credentials.  Reasons for enabling Lightweight Directory Access Protocol (LDAP) over Secure Sockets Layer (SSL) / Transport Layer Security (TLS) also known as LDAPS include: Some applications authenticate with Active Directory Domain Services (AD DS) through simple BIND. As simple BIND exposes the users’ credentials in clear text, use of Kerberos is preferred. If simp...
Post a Comment
Read more

What is Loopback - localhost address?

The local loopback mechnism is useful for testing software during development, independently of any networking configurations which means no hardware accsociated with it not physically connected to network. What is Loopback Loopback is a communication channel with only one endpoint.  TCP/IP  networks specify a loopback that allows  client   software  to communicate with server software on the same computer.  Localhost - Loopback address localhost is a hostname indicating this computer and used to access the network services running on the host via Loopback network interface. On most computer systems, localhost resolves to the IP address 127.0.0.1 in IPv4 loopback address, and to the IP address ::1 in IPv6. How 127.0.0.1 Works TCP/IP application programs generate message with IP addressess for intended recipients and TCP/IP recognizes 127.0.0.1 as a special IP address which the protocol checks before sending it and re-routes back to the receivin...
Post a Comment
Read more

Upgrade ESXi server 6.0 to 6.5 using ISO usb

Please note that this is tested with standalone ESXi server 6.0 to upgrade to 6.5. for vCenter users, vCenter 6.5 must be upgraded before upgrade each ESXi host. Preparation It is good idea for you to have a review on follow docs during preparation for the upgrade. 1.  VMware vSphere 6.5 Release notes 2.  KB article about VMware update sequence for vSphere 6.5 and compatible VMware product 3.  Important information before upgrading to vSphere 6.5 Prerequisite 1. Download VMWare vSphere Hypervisor (ESXi) offline bundle ISO file from  vmware download page . 2. Create USB stick with bootable ISO of ESXi 6.5 upgrade. => I am using  rufus tool  to create bootable USB stick. This is free software. How to do steps 1. Reboot ESXi server and change boot order to USB first 2. You will be directed to installation process. -> select disk with ESXi 6.9 installed on . ->  Select Upgrade option and OK -> Once it's done reboot syst...
Post a Comment
Read more