Using Manually-Defined Workload Views

Use the following steps to manually define your own Workload Views, or if you want to see this feature in action, view the following video:

Video: Classifying Workloads to Gain Insights

Figure 1. Video: Classifying Workloads to Gain Insights

For better video quality, click YouTube in the lower right corner of the video player to watch this video on YouTube.com.

  1. In the left menu under Data Warehouse, select Summary, and click the arrow next to the date range in the upper right corner of the page to select the date range for the workloads you want to analyze:



  2. In the left menu, under the Data Warehouse heading, select Define New > Manually define view. Then click Define New:



  3. On the Define Data Warehouse Workload View page where you can define a set of criteria that enables you to analyze a specific set of queries. For example, you can review all failed queries using a specific database that are subject to a fifteen second SLA:



    The above workload view definition, which is named my_dino_view, monitors queries that use the dino database. When 15 percent of these queries miss a 15s SLA, that is total query execution time exceeds 15 seconds, then the workload is flagged with a failing status.

  4. After specifying your criteria, click Preview and a summary of the queries matching this criteria displays:



  5. If you are satisfied with the results of the criteria you specified, click Save in the lower right hand corner of the page.

  6. After saving the workload view, you are returned to the Data Warehouse Workloads page, where your workload appears in the list. Use the search bar to search for your workload and click on the workload to view the workload details:



  7. The detail page for your workload view contains several graphs and tabs you can view to analyze how this group of queries is meeting its SLA. For example:

    • In the Trend region, you can view the counts of executing queries By Status or By Statement Type:



      Click the number under Total Queries, Failed Queries, and Query Active Time to view further details.

    • Also in the Trend region, you can view the number of queries executing concurrently when you click the Concurrency tab:



      In the above example, it shows that the maximum concurrency for this workload view is 20. This means that for the queries in this workload view, a maximum of twenty queries access the same data at the same time during the specified time period. At the bottom of the graph, it shows how concurrency fluctuates over the date range specified for the workload view.

    • You can also view the different statement types contained in the workload view, the active time of the queries, and you can drill down to view more granular details on each query.

    • In the other widgets on the page you can view things like which queries took the most time, what statement type was the most common, and details of failed queries.