THWACK [Mini] Mission: Database Performance Analyzer (DPA)
In a bid to get in front of an ever-evolving world and ever-changing environments, some of the smartest engineers built the first man-and-machine hybrid. When you first opened your eyes, it was to the astounded and exhilarated faces of those scientists and engineers and a room full of applause.
But that was just the beginning. Since then, you’ve been tasked with monitoring all the lands. It would have been an impossible task if you weren’t a hybrid of on-prem and cloud. This way, whatever the environment you’re monitoring, you always keep pace and adapt. Whispers follow you through the streets… as you pass, you hear them say, “there goes DPA.”
Ready to put your great power to use? Start the mission!
OCTOBER MINI MISSION
Correctly answer each question during the week and you'll be entered for a chance to win the weekly prize.
Correctly answer all 10 questions over the course of the month and you'll be entered for a chance to win the grand prize.
150 points are being awarded for each correctly answered question. There are 10 questions, which means you can earn a maximum of 1,500 points for this mission.
Want to join the mission, but not a member? Sign up FREE now!
PRIZES
October 28th, 2019: Portable Turntable
November 4th, 2019: Echo Show
Grand Prize:
November 4th, 2019: Key Free Smart Lock
MISSION RULES
MISSION SHORTCUT
Complete the mission shortcut between October 21, 2019 and November 3, 2019 to be entered to win a Sonos Beam – Sound Bar
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
WEEKLY PRIZES | MON | TUE | WED | THU | FRI | WINNERS |
---|---|---|---|---|---|---|
Correctly answer all 10 questions by November 3rd 2019 and get entered to win the Grand Prize! Key Free Smart Lock |
Mini Mission Terms and Conditions: US, UK, and Canada | Germany | Australia
Mission Shortcut Terms and Conditions: US, UK, and Canada | Germany | Australia
Top Comments