This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
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

Go to solution
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

Go to solution
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