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.
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.