topic Identify the lead blocking SQL Statement on a monitored server in Extensions https://community.dynatrace.com/t5/Extensions/Identify-the-lead-blocking-SQL-Statement-on-a-monitored-server/m-p/223096#M3382 <P>I'm looking for a way in Grail, if possible, to identify the lead blocking SQL Statement on a monitored server.&nbsp; I'm pretty new to both Dynatrace and Grail.</P> <P>Any help is appreciated.</P> <P>Thanks.</P> Tue, 12 Dec 2023 14:38:40 GMT bcweatherford 2023-12-12T14:38:40Z Identify the lead blocking SQL Statement on a monitored server https://community.dynatrace.com/t5/Extensions/Identify-the-lead-blocking-SQL-Statement-on-a-monitored-server/m-p/223096#M3382 <P>I'm looking for a way in Grail, if possible, to identify the lead blocking SQL Statement on a monitored server.&nbsp; I'm pretty new to both Dynatrace and Grail.</P> <P>Any help is appreciated.</P> <P>Thanks.</P> Tue, 12 Dec 2023 14:38:40 GMT https://community.dynatrace.com/t5/Extensions/Identify-the-lead-blocking-SQL-Statement-on-a-monitored-server/m-p/223096#M3382 bcweatherford 2023-12-12T14:38:40Z Re: Identify the lead blocking SQL Statement on a monitored server https://community.dynatrace.com/t5/Extensions/Identify-the-lead-blocking-SQL-Statement-on-a-monitored-server/m-p/231646#M3770 <P>Just a couple of clarifying questions:</P><OL><LI>Are you looking for a statement that causes the most total block time within a given time window?</LI><LI>How do you currently collect information about queries?</LI><LI>Do you have the latest 2.0.0 remote SQL Server monitoring extension installed?&nbsp;</LI></OL> Tue, 12 Dec 2023 16:12:56 GMT https://community.dynatrace.com/t5/Extensions/Identify-the-lead-blocking-SQL-Statement-on-a-monitored-server/m-p/231646#M3770 vagiz_duseev 2023-12-12T16:12:56Z