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.
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
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!
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
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.
Learn more today by joining now.