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

THWACK [Mini] Mission: "X" Marks the Spot

Community Manager



A fountain of database enlightenment awaits you, but will you embark on this mission to find it?

As lore would have it, a DBA’s treasure of performance intelligence was said to exist in the data center, yet was never found. But now, thanks to intriguing database discovery, the tables are turned and its riches are now within your reach. Grab your trusty mug and prepare to cast off from your current environment in search of enlightened database performance and desirable loot (aka cool prizes).

Sources tell you that Database Performance Analyzer (DPA) 12.0 has the map you’re seeking. Start exploring with Query Performance Analyzer and you’ll find that continual monitoring for inefficient query data access can take the heavy lifting off your shoulders. Database Performance Analyzer can also help you find the queries causing the database engine (and your systems) to work really hard for very little return. Look for Table Tuning Advisors along the way. Discover how you can aggregate the workload from those queries at the table level, supplying the necessary information to help make better proactive tuning and optimization decisions.

Go forth and navigate perilous low ROI queries, missing indexes, and table workloads to dig into a wealth of correlation and analysis. “X” marks the spot for optimizing your database performance!

Start the mission now for a chance to increase your knowledge and win prizes. Good luck!



OCTOBER MINI MONTHLY 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: Nintendo Switch


Want to join the mission, but not a member? Sign up FREE now!

PRIZES

Weekly Prizes & Drawing Dates:

October 15: Model Shipways Phantom Ny Pilot Boat

October 22: LEGO Lord of the Rings Pirate Ship Ambush


Grand Prize

October 22: Nintendo Switch

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.



MISSION SHORTCUT

Complete the mission shortcut to earn an additional 1,000 THWACK® points & enter to win a Sonos Beam - Compact Smart TV Soundbar!

The shortcut is simple:

  1. Download a Free Trial of Database Performance Analyzer!
  2. Take a screenshot of table detail within the new table tuning adviser feature.
  3. Submit your screenshot below.

 

MISSION RULES

A new question will open every day (Monday - Friday) starting on October 8th, 2018. Once a question has opened, it will remain open until October 21st, 2018. Check the schedule below for exact open/close times.



Weekly PrizesMonTueWedThuFriWinners
Week 1: Complete questions 1-5 by October 14, 11:59 PM CDT to be entered to win: Model Shipways Phantom Ny Pilot Boat
Week 2: Complete questions 6-10 by October 21, 11:59 PM CDT to be entered to win: LEGO Lord of the Rings Pirate Ship Ambush

Correctly answer all 10 questions by October 21, 11:59 PM CDT and get entered to win the Grand Prize! Nintendo Switch



Monthly Mini Mission Terms and Conditions: US, UK, and Canada | Germany | Australia

Monthly Mini Mission Shortcut Terms and Conditions: US, UK, and Canada | Germany | Australia

87 Comments
Level 9

I can't see Monday's question yet

Level 9

It's monday the 8th, where would the question be?

Level 10

pastedImage_0.png

Aye, it's definitely bust at the minute...

Level 10

Cool prizes for this mini-mission. Might even do the shortcut on this one as well.

Level 12

First question should be up! I apologize for that, there was a bit of an error in communication with the question. The rest should be populating here momentarily.

Good luck to everyone!

A great first question--which can be answered with common sense.  Thanks for the mini-mission!

Level 12

You bet! I really love the theme for this one too.

Level 8

No Thwack points for these questions?

Level 12

Should be? When did you answer it?

Edit: Just double checked. I was awarded the 150 points for the question. I just didn't have the text saying you earned 150. Let me know if you're not seeing the point increase though on your end.

Level 8

Maybe an hour or so ago, I am just shy of 99k so I was expecting that to put me over. Still not added.

Level 12

Probably right before I put in the action for points. Give me just a minute and we'll push you over that edge!

EDIT: Should be all set now!

Level 8

Got them, thank you very much.

Level 11

I got the message stating I got the answer right and should be awarded 150 points, but I never did receive them. Can someone check on that please?

Level 12

Sure can! It'll be just a moment.

EDIT: Should be good now! You'll have the points and badge now.

Level 11

Thanks, they show up now!

Level 7

Can I join this mission?

Level 12

Anyone is welcome to join the mission. You'll earn points and knowledge regardless of where you're from

Just be aware that the prizes however are limited to the US,UK, Canada, Germany, and Australia as it stands.

Level 12

Love the mini missions. We have lots of db's in house, so am learning a bit more than usual 🙂

Level 12

Really happy to hear that they're working as intended!

Level 16

Thanks for the Mini Mission!

Just a quick note about the text of the shortcut. The screen above shows:

  1. Download a Free Trial of Database Performance Analyzer!
  2. Take a screenshot of the console showing either one physical or virtual server successfully backed up.
  3. Submit your screenshot below.

Backups don't really make sense for DPA - following the Submit Screenshot link shows that the mission shortcut is asking for:

Take a screenshot of table detail within the new table tuning adviser feature

Level 12

Good catch! It's been adjusted and should reflect the proper text from the actual link. Apologies for that.

Level 12

Seen that on Monday but didn't want to be a PITA

thwack2.png

But glad to see correction marcoswithanoh

Level 14

Ugh....missed today's question.  I hate to say it confused me but it did.

Level 12

Always feel free to point these out to me! It's better to get them found out sooner rather than later. No worries either way

Level 13

Looks like my points from the 8th didn't register either.  Following 2 days do appear to have been added.

Level 12

Give me a moment and I'll have those updated for you!

EDIT: You should be all set now.

Level 13

Looks like they're there now.  Thanks.

Maybe someday I'll get around to spending some of them.

Level 9

How is Tuesdays question not false? It references a "treasure map" in the question.

Level 14

I think they are switching up the terminologies used in this mini-mission.  This difference caused me to miss today's question as well. 

Level 9

Anyone have any insight on this question/answer for today? Definitely has tripped up alot of people and the terminology is different. There are definitely two views on the one map(view)page you can use for data analysis, but I have it on good authority the answer is not two.

Level 9

Or QPA could be considered one view even though you may need to move between the 3 tabs to gather all the data. Not sure if the Tabs are individual views or are just part of the QPA view. I'll log into the Demo environment and see if they have it built out to test.

Level 12

Can I offer a "Marcos" hint? Reading the last line of the question out loud helped me a lot with this one.

Level 9

I see what you did there...

Hey, marcoswithanoh​, I have a question on Q3 (trying to catch up from being gone).  What am I missing here:

pastedImage_0.png

And yet the answer is not two.  Obviously there was something I missed here so I would appreciate any clarification you can give.

Thanks.

One other thing, and I don't know if it's just me, but my points just say "Loading points..." and the store does not open either (not that I'm looking to get anything right now, just bringing it up).

pastedImage_0.png

Level 12

I'm going to see if I can tag the right person to come take a look into the specific clarification to use.

But from my own personal experience/reading, I was under the impression that the whole thing was simply one view. While it does specify there's two main areas, the whole thing itself is a single view. I could be COMPLETELY dumb and wrong about this, so I apologize in advance.

Level 12

Double checked on this for you but the store itself loaded up just fine for me. Good ol' fashion refresh do anything?

Level 14

If you look at the 2nd paragraph, first sentence: "QPA is designed to intelligently assemble current and historical data for a query, combining all the information about a query into one place"

That should help you get there...

Level 13

Love the mini missions.

Level 12

Glad to hear it!

Sadly, no.  Even rebooted my computer because microsquash products were misbehaving.  I have not tried a different browser yet, nor have I looked into our firewall possibly blocking something (but I would think that, if that were the case, I wouldn't be able to get to THWACK.com at all...) but if you are able to see it then it must be me.

"When you have eliminated the impossible, whatever remains - however improbable - must be the truth." - Sherlock Holmes

Level 12

Yeah just sanity checked myself and tried opening it again just in case. No problem here. You got this! I know you'll get to the bottom of it.

Level 11

The answers are pretty clear in the Hint documentation.  So far nothing tricky.

Well, it would have, mandevil​, had I not overthought things.  Two areas, One "view" (even though the word "view" is not in the hint, but I'll ignore that...;-).  And I don't mean to be whiner, just wanting to learn and understand how the product functions, that's all.  Thanks for the feedback!

Some questions need no viewing of the hint.  Today's is a perfect example of common sense eliminating the incorrect answers. (October 12, Question 5).

Level 11

OK, I am very sure I got today's question right.  The answer I chose was worded EXACTLY what the blog said.

Why did I get marked wrong?

Level 9

It shows Friday's question as being on the 20th, not the 19th. Typo?

Also, the video link wasn't working on one of the questions (I forget which, sorry!)

Level 12

I'll take a look through to find which one. I also edited the date, nice catch!

Level 12

Which answer did you wind up selecting?