THWACK Monthly Mission - October 2017
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.
SolarWinds
Database Performance Analyzer (DPA) has your back by monitoring all of your databases from SQL Server 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!
OCTOBER MONTHLY MISSION
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!
PRIZES
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 XMISSION SHORTCUT
points & enter to win 1 of 10 sets of DBA Disruptors! 
The shortcut is simple:
- Download Database Performance Analyzer
- 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?!
Submit a screenshot of your chosen view
MISSION RULES
| Weekly Prizes | Mon | Tue | Wed | Thu | Fri | Winners |
|---|---|---|---|---|---|---|
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
Top Comments