Comments
-
Thank you, @danrcarollo! This request has been added to the SQL Sentry roadmap and we'll reach out when we've added it to the product. Thanks for submitting this request and for your continued use of SQL Sentry!
-
@tobyw_loop1 I just double-checked the link and it works for me. This has been confirmed by another Thwack user. Can you please try again? Thanks!
-
@"shantanu167" We are still working on the query, sorry for the delay. I want to clarify what you are after. Do you simply want to know if the cumulative blocking (across all sessions) is > 5 minutes in the last hour? Or do you need more detail than that (e.g. which sessions were blocked > 5 minutes)?
-
@"shantanu167" yes, I see your point. The query that I provided only measures the time that a session "directly" blocked other sessions, and does not include the impact of indirect blockers. As you can see, in your screenshot, session 96 (a blocker) has 4 direct blockees. Each direct blockee was blocked for 16 seconds (16…
-
Hello, @"shantanu167" Here is a query that should do the trick. Let me know if this doesn't do what you had envisioned. DPA Repository Query to find Blocking Sessions
-
Andy, Thank you for the inquiry! The health score in Portal includes closed alerts. The thinking here is that, even though an alert was closed, the issue still occurred and thus affects the health score. In addition, a closed alert does not necessarily indicate that the issue has been resolved. If the alert is truly…
