FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Identify the lead blocking SQL Statement on a monitored server

bcweatherford
Observer

‎14 Sep 2023 08:13 PM - last edited on ‎12 Dec 2023 02:38 PM by Community Team

I'm looking for a way in Grail, if possible, to identify the lead blocking SQL Statement on a monitored server.  I'm pretty new to both Dynatrace and Grail.

Any help is appreciated.

Thanks.

Labels:
Reply
1 REPLY 1

vagiz_duseev
Dynatrace Helper
Dynatrace Helper

‎12 Dec 2023 04:12 PM

Just a couple of clarifying questions:

  1. Are you looking for a statement that causes the most total block time within a given time window?
  2. How do you currently collect information about queries?
  3. Do you have the latest 2.0.0 remote SQL Server monitoring extension installed? 
Reply
Ask a question

Featured Posts