Configuring Sessions with SQL and Explain Tabs

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K
The Sessions data collector collects all details for a session and the currently running request. SQL and Explain text is collected when the Enable SQL and Explain check box is selected and when SQL and Explain thresholds are met. Query band information is collected when the Enable SQL and Explain check box is selected and when either SQL and Explain thresholds are met or for utility sessions. The SQL and Explain thresholds can be set high or low and corresponding SQL and Explain text appears in the SQL and Explain tabs in query details views. The SQL associated with a query can help you target and optimize the query. The Explain text shows a query's progress through the Explain plan so you can optimize the query and change the Explain plan.

The Teradata Viewpoint system is configured to collect longer-running queries when SQL and Explain collection is enabled. Set the threshold lower to include shorter running queries, which may increase performance overhead.

The explain plan progress for all queries is updated at the collection rate of the Sessions collector. If you want to fetch the latest explain plan progress for a particular query more frequently than that rate, you can do so in the Query Monitor or Query Groups portlets. You can enable this feature per role by granting the Get Explain from DB permission for one or both of these portlets in Roles Manager.

  1. From the Systems list, click the name of the system you want to update.
  2. From the Setup list, click Data Collectors.
  3. Click the Sessions data collector.
  4. Select the Enable SQL and Explain check box.
  5. Under SQL and Explain Thresholds, set one or more thresholds:
    • Elapsed seconds
    • Total CPU seconds
    When a threshold is exceeded, SQL and Explain text is collected for the session and the SQL and Explain tabs appear in query details views.
    Setting SQL and Explain thresholds too low might impact your system performance.
  6. Click Apply.