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

After doing both the mini mission and the regular daily question I noticed I did not get the 150 points for either of the correct answers I gave, Just an FYI !

Thanks

Level 10

I noticed the same this morning.

Level 13

Same

Level 14

Same - no points.

Level 9

same

Level 9

Add me to the list as well, no points awarded.

edit

After I did the regular mission's question, all of my points were awarded. Thanks!

/edit

Add me to the list yumdarling​ No points for either of today's questions.

Level 11

Same here, no points

Level 8

Same...No Points

Will wait until later for the monthly mission question for today.

Community Manager
Community Manager

Hey Shane,

I just checked and I can see that you got two 150 points today at 6:48am (probably in ET, which is my time zone).

Let me know if you still don't see your points in your account by the end of the day.. sometimes it takes a hot minute.

Meanwhile, I'll go and complain and see if there's a software issue.

Thanks!!

Yum

Level 14

Mine actually showed up, but at the time of my post it had not.  Thanks for following up yumdarling​!

Level 9

Mine did show up, but it was after I’d completed the other question, sorry I forgot to update my post. I’d still complain if I were you, everyone who works in a Help Desk position loves complaints! 😁

Level 8

Same

Level 10

Same.

Level 8

I got my points for both after completing todays question in the monthly mission... if that helps anyone

Level 10

Just a heads up, I had no points awarded for 10/22. Not sure about yesterday.

...NVM. When I did the other mission, I got credit for both at the same time. Not sure if coincidence or a glitch. 

Level 14

Something wonky is going on with the points system.  I noticed I got 300 points after the main mission this morning.  After checking, I got 150 for the main and 150 for this one as well, even though I hadn't answered the question yet.  After answering the question correctly there was no change.  But I do wonder if I'd gotten today's question wrong if there would've been no change as well and I'd get 150 points anyway.  Weird.

yumdarling​  two days in a row no points for the correct answer

Level 9

DPA can monitor 99 DBs but MS Access ain't one!  (I'm not liable if you take this comment as fact. )

Community Manager
Community Manager

Hi Jeremy!

Your points were awarded through the gamification plugin. If you don't see them hit your account by the end of the day, feel free to DM me.

Thanks,

Yum

Level 10

As far as I can tell I have no points for these two, just to add to the list.

Level 7

No points awarded for either question

Community Manager
Community Manager

Just so that I'm being clear - the points ARE being awarded... I can see the transaction on the back end of the gamification console. If you've answered today's question correctly, 150 have been rewarded to you.

If you are not seeing them in your account, feel free to shoot me a DM (so we aren't clogging up the comments) with how many points you have and what browser you're on. We'll see if we can figure out why it's taking a hot minute for the points to show up.

Thanks!

Yum

Level 12

great we bought that software

Level 12

hi, sorry no 150 points for each correct question, can you solve this please?

Level 12

hi, i didn't get points for dpa mini  mission. i have 3 correct answers now. i can't see any record in activity too.

Level 8

No points for this mission for any of the questions this week (as far as I can see!)

Level 14

My points for this mission are being automatically awarded when I answer the main monthly mission question correctly.  If you go to your profile, and click on your points total, it shows you a history of points being awarded.  You can see this there. 

Level 8

yumdarling I've done a little digging regarding the points strangeness that keeps being mentioned, and I think I may have found something.

Both yesterday and today I have answered the questions for the mission and mini-mission separately to try and determine when the point total changes. When I answer the question for the mini-mission the points are not awarded at that time, but when I answer the question for the main mission, both events trigger simultaneously. It seems to be independent of the interval between the answers as well as the order.

I also tried browsing around the Thwack site in-between answers to see if there was another trigger, but couldn't come across anything.

pastedImage_0.png

Level 14

Right - I mentioned this both yesterday and today. 

Level 14

ditto

Level 12

thanks for the tip, i wait till tomorrow with october daily mission and see if there's some credit on activity section

Level 11

yumdarling

No points are added for correct answer, total points remain same.

/msarkar

Level 9

yumdarling Todays question (Oct 24th) I answered the question correctly and got a red X.

The text saying what the correct answers were confirmed that I had answered correctly..

Level 9

Got a big red X for correctly answering too.

Level 11

Got the same thing this morning... Thought I was going a little a little bit crazy >.<

Level 11

Correct answer given - marked wrong for getting it right?!!

Level 8

Me, too!

MVP
MVP

Me, three.

Paging yumdarling​ for verification, can you confirm the question is correct please?

Level 8

Same here

Level 8

Today's question required resetting I have answered correctly but it went wrong .:(

Level 8

Same here

Level 9

And me

Level 9

AND me, sure I ticked both boxes?!?!?!?!

Level 7

Same here, answered the two correct answers but marked incorrect

Level 9

Same here, the correct boxes selected and still it said it was wrong.

Level 12

yumdarling today i got a big red x too for answering correctly. Can you reset the question?

Level 9

same for me

Level 9

Add another one to the list, ticked both and still got a 'Nope'

Level 12

Same here!