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