Checking DWS Workload Reports

Notes and Constraints

• The WDR function is available only in 8.1.1.300 and later cluster versions.
• Workload diagnosis reports can be stored only in OBS.
• Before creating a workload snapshot, ensure that the performance view snapshot, resource monitoring, and logical memory management module are enabled. For details, see Configuring Workload Snapshot Parameters.
• To create a workload report, obtain the required OBS bucket permissions first.

Configuring Workload Snapshot Parameters

1. Log in to the DWS console.
2. Choose Cluster > Cluster List and locate the cluster whose load needs to be analyzed.
3. In the Operation column of the cluster, choose Monitoring Panel. The database monitoring page is displayed.
4. In the navigation pane, choose Workload Analysis > Workload Snapshot. Workload snapshots will be displayed.
5. Click Configure Snapshot in the upper right corner. In the dialog box that is displayed, check or modify GUC parameters. For details, see Table 2.

   

   Table 1 Workload snapshot parameters

   Parameter	Default Value	Description
   Performance View Snapshot (enable_wdr_snapshot)	off	Whether to enable the performance view snapshot function. After this function is enabled, DWS will periodically create snapshots for some system performance views and save them permanently. In addition, it will accept manual snapshot creation requests.
   Resource Monitoring (enable_resource_track)	on	Whether to enable the resource monitoring function. Resource statistics parameters are valid only if this parameter is enabled.
   Logical Memory Management (enable_memory_limit)	on	Whether to enable the logical memory management module.
   Wait Event Statistics (enable_track_wait_event)	off	Whether to collect statistics on wait events, including the number of occurrences, number of failures, duration, maximum waiting time, minimum waiting time, and average waiting time.
   I/O Call Time Series Statistics (track_io_timing)	off	Whether to collect time series statistics on database I/O calls. If this function is enabled, the collector will periodically query the OS time, which may cause heavy overhead on certain platforms.
   SQL Count (track_sql_count)	The default value is off for versions earlier than 8.1.3 and on for 8.1.3 and later versions.	Whether to collect statistics on the number of the SELECT, INSERT, UPDATE, DELETE, and MERGE INTO statements that are being executed in each session, the response time of the SELECT, INSERT, UPDATE, and DELETE statements, and the number of DDL, DML, and DCL statements. This parameter takes effect only if track_activities is set to on.
   Session Command Statistics (track_activities)	on	Whether to collect statistics on the commands that are being executed in each session.
   Unique SQL Statistics (instr_unique_sql_count)	0	Whether to collect unique SQL statements and how many statements can be collected.
   Snapshot Creation Interval (wdr_snapshot_interval)	60	Interval for automatically creating performance view snapshots. It must be longer than the time needed to create a snapshot. The unit is minute.
   Maximum Snapshot Age (wdr_snapshot_retention_days)	8	Maximum retention period of performance snapshots. A large value will require a lot of disk space. The unit is day.

6. Confirm the information and click Save.

Creating a Workload Snapshot

1. Log in to the DWS console.
2. Choose Cluster > Cluster List and locate the cluster whose load needs to be analyzed.
3. In the Operation column of the cluster, click Monitoring Panel. The database monitoring page is displayed.
4. In the navigation pane, choose Workload Analysis > Workload Snapshot.
5. Click Create Snapshot. Enter a snapshot name and click OK.

Generating a Workload Report

1. Log in to the DWS console.
2. Choose Cluster > Cluster List and locate the cluster whose load needs to be analyzed.
3. In the Operation column of the target cluster, click Monitoring Panel. The database monitoring page is displayed.
4. In the navigation pane, choose Workload Analysis > Workload Reports.
5. Click Generate Report. In the displayed dialog box, configure the following parameters and click Save.

   Table 2 Parameters for generating a report

   Parameter	Description	Example Value
   Report Name	Custom. The name can contain a maximum of 100 characters, including digits, letters, and underscores (_).	test_show
   Node Type	The options are as follows: node: The performance data of a specified node will be provided. cluster: The performance data of the entire cluster will be provided.	node
   Node Name	Custom	dn_6005_l006
   Content Type	The options are as follows: summary: A report contains only brief analysis and calculation results. detail: A report contains only detailed metric data. all: A report contains content of both the summary and detail reports.	all
   Starting Snapshot	Custom The time of the starting snapshot must be earlier than that of the ending snapshot.	-
   Ending Snapshot	Custom	-
   OBS Bucket	Bucket name, which is used to store reports	test123
   OBS Path	Storage directory, which can be customized. Multi-level directories can be separated by slashes (/) and cannot start with slashes (/). Up to 50 characters are allowed.	wdr

Managing Workload Reports

1. Log in to the DWS console.
2. Choose Cluster > Cluster List and locate the cluster whose load needs to be analyzed.
3. In the Operation column of the target cluster, click Monitoring Panel. The database monitoring page is displayed.
4. In the navigation pane on the left, choose Workload Analysis > Workload Reports. You can view, download, delete, and configure parameters of workload reports. The following table lists the operations.

   Table 3 Workload report management operations

   Operation	Description
   Downloading reports	Select reports and click Download. Up to 10 reports can be downloaded at a time.
   Deleting reports	Select reports and click Delete.
   Deleting a report	Click Delete in the Operation column of a report to delete the report record and file.
   Configuring reports	Click Configure Report in the upper right corner. In the displayed dialog box, set the report retention period and OBS parameters. For details about OBS settings, see Table 2.