THWACK Monthly Mission - October 2017

When there is no more room in the database, the disruptors will walk the earth!

Your database is your sanctuary, and you must defend it against the disruptors. Your mission this month is to defeat each disruptor in your path. Along the way you will encounter Performance Hog, Blame Shifter, and Query Blocker.

SolarWindsRegistered Database Performance Analyzer (DPA) has your back by monitoring all of your databases from SQL ServerRegistered to the cloud in one installation and gives second-by-second analysis. Time is key in any battle against database disruptors (or trick-or-treaters). We have you covered in the ongoing battle against poor database performance!

Good luck on your October Mission THWACKsters, and enjoy your Halloween candy!


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 20 questions over the course of the month and you'll be entered for a chance to win the grand prize: A Xbox One X!


Weekly Prizes & Drawing Dates:

October 9: Nightmare on Elm Street Freddy Krueger Bread Toaster
October 16: Halloween Window Projector
October 23: Stranger things vinyl + Stranger things travel mug
October 30: Alfred Hitchcock Collection Blu-Ray

Grand Prize

October 30: Xbox One X

150 points are being awarded for each correctly answered question. There are 20 questions, which means you can earn a maximum of 3,000 points for this mission.


Complete the mission shortcut to earn an additional 1,000 THWACKRegistered points & enter to win 1 of 10 sets of DBA Disruptors! disruptors
The shortcut is simple:
    1. Download Database Performance Analyzer
    2. Give us a view that represents your favorite disruptor (Performance Hog, Blame Shifter, or Query Blocker)
      • Performance Hog: He’s the process that just keeps consuming. Yeah, he’s that guy that will take the last chicken wing off your plate and say “you weren’t going to eat that were you?” This would be the SQL statement you see consistently popping up as the most impactful in the charts. Think of a select with numerous joins without a where clause (nothing to filter by).

      • Query Blocker: He’s the guy with the broken down 1984 lemon in your lane! Your stuck. You are going to be late for work. Look for the SQL transaction in your database that doesn’t commit or rollback – yeah, that’s the guy. He causes all kinds of blocking waits. He may even have rolled an external dependency into the transaction.

      • Blame Shifter: He’s subtle. He makes his appearance when applications slow down, but no one knows what the issue is. This when everyone starts pointing fingers! No one wins the blame game, except Blame Shifter. Is it the query itself? Is it the database configuration? Is it the data model? Is it the infrastructure? Where do you even begin?!

    3. Submit a screenshot of your chosen view


A new question will open every day (Monday - Friday) starting on October 2, 2017. Once a question has opened, it will remain open until October 29, 2017 at 11:59 p.m. CDT. Check the schedule below for exact open/close times.

Weekly PrizesMonTueWedThuFriWinners
Week 1: Complete questions 1-5 by October 8 to be entered to win: Nightmare on Elm Street Freddy Krueger Bread Toaster
Week 2: Complete questions 6-10 by October 15 to be entered to win: Halloween Window Projector
Week 3: Complete questions 11-15 by October 22 to be entered to win: Stranger things vinyl + Stranger things travel mug
Week 4: Complete questions 16-20 by October 29 to be entered to win: Alfred Hitchcock Collection Blu-Ray

Correctly answer all 20 questions by October 29 and get entered to win the Grand Prize! Xbox One X - release date 11/7

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

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

Parents Comment Children
No Data