cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

THWACK [Mini] Mission: Database Performance Analyzer (DPA)

Community Manager
1909_thwack_October_DPAminimission_noCTA_900x300.png

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

Use the mission’s resources to complete the tasks and answer the questions for a chance to win!

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

Weekly Prizes & Drawing Dates:
October 28th, 2019: Portable Turntable


November 4th, 2019: Echo Show


Grand Prize:
November 4th, 2019: Key Free Smart Lock



MISSION RULES

A new question will open every day (Monday - Friday) starting on October 21st, 2019. Once a question has opened, it will remain open until November 3rd, 2019 at 11:59 p.m. CT. Check the schedule below for exact open/close times.



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

3. Submit screenshot

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

3. Submit screenshot

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

4. Submit screenshot

DOWNLOAD FREE TRIAL  SUBMIT SCREENSHOT

WEEKLY PRIZESMONTUEWEDTHUFRIWINNERS
Week 1: Complete questions 1-5 by October 27th 2019 to be entered to win: Portable Turntable
Week 2: Complete questions 6-10 by November 3rd 2019 to be entered to win: Echo Show

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

67 Comments
Level 9

Same for me. Selected the two check boxes and then the question is marked wrong. The notes in the answer indicate I choose correctly but it is marked wrong.

yumdarling​ - please can you check the question and reset, something is not correct with the question on October 24th.

Level 10

And again for me!

Should have looked here first

Community Manager
Community Manager

Thanks for tagging me. I fixed the issue and reset the answers.

Level 10

Thank you

Level 9

Many thanks

Level 11

Thank you

Level 11

Thank you yumdarling

Level 12

thanks a lot

Level 11

I got a whole week green for once!!!!!! now if I could win something I would be even happier

MVP
MVP

Today's question needs a little work although I did answer it correctly.

pastedImage_0.png

And the hint doesn't work either It should be Cloud Performance Optimization – Database Management System | SolarWinds

Level 14

The hint leads to

NOT FOUND

The item does not exist. It may have been deleted.

Level 11

I wish I did! I misclicked submit instead of cancel as I wanted to check the comments! Haha!

Lesson learned!


Level 11

Hi Peter,

Long time no speak! Hope you are well!

There is an issue with the embedded link... If you look at the URL when you click the hint, it will show what it should be...

Cloud Performance Optimization – Database Management System | SolarWinds

Although, as I type this, I think the link may now be resolved

Level 8
Level 12

I was a little bit hesitant to "click" the button today, but remember to check the comment section.

Thanks jaywi11

Level 13

Thanks jaywi11​. I didn't find the answer in the provided hint, but I did in yours.

MVP
MVP

It's tough being in my time zone

pastedImage_0.png