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.
Although we can pick an hour and see details of all blocks, it would be handy to have a report to see what are the top blockers in the system. Root blockers don't usually appear on the waits page due to how they work. If a root blocker running for 2 mins blocks 10 executions of a different sproc, each lasting 30 seconds…
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…
There are some alerts related with only blocking duration (under General Conditions, SQL Server: Blocking SQL, SQL Server: Blocking SQL Duration Threshold Max), not for blocking count. If blocking count greater than 5-10 it could be critial issue and it may cause increase active session count and server resource…
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.
Description This alert will run against the monitored Oracle databases and retrieve the time a session has been waiting ("Seconds Blocked" column) on a blocking session. It will also give some details about the blocking session in the "Message" column and this can be customized with anything else from v$session. ALERT…
Description This alert will run against the monitored instance and retrieve the time each session has been blocked ("Seconds Blocked" column). It will also give some details about the blocking session in the "Message" column and this can be customized with anything else from sys.dm_exec_requests DMV. Alert Definition To…
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…
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…
I found that the "Blocking sessions" graph shows me multiple sessions being blocked. But when i want to check which ones, the blockers list does not list all of them, if any. Am I missing something?
It looks like you're new here. Sign in or register to get started.