Identify the biggest root blockers by analyzing total wait times

SolarWinds® Database Performance Analyzer (DPA) is built to collect blocking data in a feature called the Blocking Tab, which provides a high level of visibility into the root blocker (shown at the top of the tree) and its aggregated wait time. This allows database administrators to drill down into the top blocking data and see its impact on database response times. DPA can also reveal the top waiters, allowing DBAs to quickly pinpoint their top blockers and use this data to better optimize the queries reducing blocking the most.

Reduce blocking time by zeroing in on the most important queries

DPA provides a Top Blocking Sessions Tab dashboard to help highlight the post-lock activity in your SQL Server preventing blocked sessions from completing their transactions and releasing locks. This capability can help database administrators reduce overall blocking wait time by making it easier to reoptimize the activity of the top blocker queries and decrease the time locks are held in a SQL Server blocking chain.

Easily pinpoint waiting objects being slowed down because of blocking

In large enterprises, it can be challenging for database administrators to identify queries, programs, users, and other elements waiting on blockers and slowing down transactions. DPA offers a quick and easy remedy to this problem. The intuitive dashboard in DPA can make it easier for database administrators to identify waiters, quickly drill down into the cause of long wait times and find their blockers. All of this can be done directly from the DPA dashboard in three to four clicks.

Track idle blockers to identify the last active query

Sometimes blockers become idle, which means they’re blocking without performing any specific function. DPA is designed to track these blocker sessions backward in time to discover the last known queries running within the transaction before it went idle. Armed with this information, database administrators can more confidently collaborate with database developers to fix the application code causing idle blocking. Additionally, DPA can provide visibility into top blockers.

Get More on How to Find Blocking in SQL Server

Do you find yourself asking…

Quote Icon

"One of the best and most intuitive database performance tools on the market."

IT Company

Uncover how to find blocking in SQL Server with a database analyzer

Database Performance Analyzer

  • Easily identify what’s being blocked and what’s doing the blocking within your SQL Server.
  • Eliminate performance bottlenecks by clearing up root blockers as quickly as possible.
  • Gain access to the data needed to optimize your database performance, indexes, and queries.
EMAIL LINK TO TRIALFully functional for 14 days

Let’s talk it over.

Contact our team. Anytime.