We're sure you've seen this pest before! The Query Blocker jams up your database by placing locks on rows or tables and blocking all other access to records. And when two query blockers work together they create a deadlock bringing all database transactions to a halt. This big galoot loves to play hide and seek, too - releasing a lock just long enough to make it difficult to detect.
Stop the Query Blocker in his tracks
SolarWinds Database Performance Analyzer (formerly Confio Ignite) has a dashboard that is designed to identify blocks and their associative locks, exposing even the sneakiest Query Blocker.
Eliminate blocked queries. Download a free 14-day Database Performance Analyzer trial and find locking and blocking problems faster.
Meet The Rest of The Monsters
<style type="text/css">
img{
border:0px;
}
img a, img a:link, img a:active, img a:visited, img a:hover{
border:0px;
}
</style>
<table width=302 textalign=center>
<tr><center>
<td>
<a href="http://thwack.solarwinds.com/message/225341#225341" target="_blank" ><img src="/themes/thwack/images/DPA_monsters/ph2.png" title="Winner of the 2002 database resource eating contest. This Performance Hog is a real pig when it comes to IO, CPU, and memory resources. Degrading performance for the end users." alt="Winner of the 2002 database resource eating contest. This Performance Hog is a real pig when it comes to IO, CPU, and memory resources. Degrading performance for the end users." onmouseover="this.src='/themes/thwack/images/DPA_monsters/ph1.png';"
onmouseout="this.src='/themes/thwack/images/DPA_monsters/ph2.png';"/></a>
</td>
<td>
<a href="http://thwack.solarwinds.com/message/225340#225340" target="_blank" ><img src="/themes/thwack/images/DPA_monsters/vw2.png" title="The Virtual Vandal loves hiding critical server resource metrics needed to solve VMware database performance problems. Good luck finding them!" alt="The Virtual Vandal loves hiding critical server resource metrics needed to solve VMware database performance problems. Good luck finding them!"
onmouseover="this.src='/themes/thwack/images/DPA_monsters/vw1.png';"
onmouseout="this.src='/themes/thwack/images/DPA_monsters/vw2.png';"/></a>
</td>
<td>
<a href="http://thwack.solarwinds.com/thread/62275" target="_blank" ><img src="/themes/thwack/images/DPA_monsters/ts2.png" title="Days of your life spent pouring over useless tools trying to figure out - WHAT IS THE PROBLEM, is what the Time-Sucka’ loves best. Fo’ shizzle!" alt="Days of your life spent pouring over useless tools trying to figure out - WHAT IS THE PROBLEM, is what the Time-Sucka’ loves best. Fo’ shizzle!"
onmouseover="this.src='/themes/thwack/images/DPA_monsters/ts1.png';"
onmouseout="this.src='/themes/thwack/images/DPA_monsters/ts2.png';"/></a>
</td>
<td>
<a href="http://thwack.solarwinds.com/thread/62277" target="_blank" ><img src="/themes/thwack/images/DPA_monsters/qb2.png" title="Everyone’s least favorite QB he places locks on rows or tables and blocks all other access to records. He is also a hit at parties with the forehead- beer-can-smash trick."alt="Everyone’s least favorite QB he places locks on rows or tables and blocks all other access to records. He is also a hit at parties with the forehead- beer-can-smash trick."
onmouseover="this.src='/themes/thwack/images/DPA_monsters/qb1.png';"
onmouseout="this.src='/themes/thwack/images/DPA_monsters/qb2.png';"/></a>
</td>
<td>
<a href="http://thwack.solarwinds.com/thread/62278" target="_blank" ><img src="/themes/thwack/images/DPA_monsters/bos2.png" title="As president of the debate team, the Blame-o-saurus loves subjective information. Top weakness? Facts. Like those found by measuring response time." alt="As president of the debate team, the Blame-o-saurus loves subjective information. Top weakness? Facts. Like those found by measuring response time."
onmouseover="this.src='/themes/thwack/images/DPA_monsters/bos1.png';"
onmouseout="this.src='/themes/thwack/images/DPA_monsters/bos2.png';"/></a>
</td>
<td>
<a href="http://thwack.solarwinds.com/thread/62279" target="_blank" ><img src="/themes/thwack/images/DPA_monsters/do2.png" title="Voted 'least easy-going', the DevObstacle loves to isolate IT teams and rigidly stands between DBAs and developers. No collaboration while he's around, boy howdy." alt="Voted 'least easy-going', the DevObstacle loves to isolate IT teams and rigidly stands between DBAs and developers. No collaboration while he's around, boy howdy."
onmouseover="this.src='/themes/thwack/images/DPA_monsters/do1.png';"
onmouseout="this.src='/themes/thwack/images/DPA_monsters/do2.png';"/></a>
</td>
<td>
<a href="http://thwack.solarwinds.com/message/225349#225349" target="_blank" ><img src="/themes/thwack/images/DPA_monsters/fl2.png" title="Just like that last relationship, moving from Enterprise Edition to Standard sucks! SE Feature Leecher is going to take away your performance monitoring tools that you used to rely on!" alt="Just like that last relationship, moving from Enterprise Edition to Standard sucks! SE Feature Leecher is going to take away your performance monitoring tools that you used to rely on!"
onmouseover="this.src='/themes/thwack/images/DPA_monsters/fl1.png';"
onmouseout="this.src='/themes/thwack/images/DPA_monsters/fl2.png';"/></a>
</td>
</center></tr>
</table>