The most recent content from our members.
Why can't we see data such as Blocking (Lead Blockers and Blocked Processes), Deadlock and Connection Count (Running, Runnable, Suspended, Sleeping) graphically on main dashboard? These graphics will help us to easily and quickly provide information about the moment of the problem.
Main dashboard is not provide us information about session count (such as Active, Sleeping, Suspended, Blocked, Lead Blocker, Deadlock). We need to see when blockings happened fast. Blocking tab only show us jump latest blocking but we need to see previous blocking. We have to investigate blocking time periods, it takes…
When selected a SPID on Blocking/deadlock tab, we can not jump to same SPID’s query on topsql tab. It forward us to random query in same time range but not matched SPID. After that we search/filter that query to find the details, It takes some time when critical problem happened.
Hi, We have an issue. SolarWinds keeps deadlocking itself out. Our environment is 4 servers in two HA pools. One is primary and the other is ape pool. It's all VM's. The SWA keepalive will not update due to these deadlocks than all of a sudden I'm getting alerts saying that there has been no polling in over 10 minutes or…
DESCRIPTION This alert will detect and show deadlocks in SQL Server instance. ALERT DEFINITION To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert similar to below. Note: When DPA executes this alert, it will substitute…
Time flies when you were having fun, so I must be having a blast because Database Performance Analyzer 10.2 has arrived in a blink of an eye (just 6 months since 10.1). If you are ready, you can download it from the customer portal and for free evaluation from the SolarWinds Website. Be prepared to save hours every day as…
I have enabled deadlock alert shipped with DPA 11.1. It sends me the alert notifications, but does not tell what queries and session ids were in the deadlock, How do enhance it to show the queries and session ids. Thanks.
The new Deadlock and Blocking charts and features are a much needed addition to DPA. What I was doing prior to the feature being added was using Extended Events to capture deadlock and blocking events and reporting them via Excel/PowerQuery. The most useful way to view the deadlocks was a heat map, instead of a bar or line…
If you are using Orion, I am sure you have already heard of PerfStack (aka Performance Analysis), SolarWinds' Drag & Drop Answers to Your Toughest IT Questions. DPA did not make the first cut of PerfStack, but I am happy to announce that with the release of DPA Integration Module 11.1, you can now see DPA goodness in…
DPA currently polls the database and gathers information about long running queries. Queries that run quickly but then hold locks are not identified as problems, and the SQL text of the queries is not available. The result is that the SQL for a victim of a deadlock situation or idle blocker situation can be seen in the…
It looks like you're new here. Sign in or register to get started.