Complete the mission shortcut between October 21, 2019 and November 3, 2019 to be entered to win a Sonos Beam – Sound Bar
This shortcut has three parts. You can choose to do either one of the following shortcuts for one entry, or you can do all of them for three chances to win our shortcut prize.
Option 1
1. Sign up for a free trial of Database Performance Analyzer (DPA)
2. Install DPA and create a DPA Repository
a. Register one or more database instances
b. After DPA has collected at least two days of data
c. Select a database instance
d. Click on “Tuning” tab next to “Trends”
i. Select either a Query Advisor or a Table Tuning Advisor
ii. Select either a query or a table
iii. Take a snapshot of the screen
Option 2
1. Sign up for a free trial of Database Performance Analyzer
2. Install DPA and create a DPA Repository
a. Register one or more database instances
b. After DPA has collected at least two days of data
c. Select a database instance
d. By default, the screen associated with the “Trends” tab will be shown
i. Under the SQL tab, scroll down till you see a tab for “blocking”
ii. Select “blocking” and then the tab “Top Waiting SQL Statements”
iii. Take a snapshot of the screen
Option 3
1. Sign up for a free trial of Database Performance Analyzer
2. Install DPA and create a DPA Repository
a. Register one or more database instances
3. After DPA has collected at least two days of data
a. On the primary home screen, select “reports” in the upper-right corner
b. Once you’re on the reports page, select any database instance and any report type
i. Click on “preview report”
ii. Take a snapshot of the screen showing the report