<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: I would like to create a notebook query in order to check for the average lock time a specific service is experiencing in DQL</title>
    <link>https://community.dynatrace.com/t5/DQL/I-would-like-to-create-a-notebook-query-in-order-to-check-for/m-p/233285#M494</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/70112"&gt;@SharonGellerTip&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;It may be that the metric you are looking for might not be available in Grail as of yet you can allways check what we have available as built in metrics&amp;nbsp;&lt;A href="https://docs.dynatrace.com/docs/observe-and-explore/metrics/built-in-metrics-on-grail" target="_self"&gt;here&lt;/A&gt;&lt;/P&gt;&lt;P&gt;If you do find that the metric you are looking for is in that list then you can write some DQL like this to get the result you are looking for:&amp;nbsp;timeseries Lock_Time=avg(&amp;lt;metric_name&amp;gt;)&lt;/P&gt;&lt;P&gt;Here is an example of querying avg CPU consumption:&lt;/P&gt;&lt;P&gt;timeseries cpu=avg(dt.host.cpu.usage)&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="luke_hearth_0-1704300058380.png" style="width: 400px;"&gt;&lt;img src="https://community.dynatrace.com/t5/image/serverpage/image-id/16592iBE7F98013E151B2A/image-size/medium?v=v2&amp;amp;px=400" role="button" title="luke_hearth_0-1704300058380.png" alt="luke_hearth_0-1704300058380.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 03 Jan 2024 16:41:22 GMT</pubDate>
    <dc:creator>LukeHearth</dc:creator>
    <dc:date>2024-01-03T16:41:22Z</dc:date>
    <item>
      <title>I would like to create a notebook query in order to check for the average lock time a specific service is experiencing</title>
      <link>https://community.dynatrace.com/t5/DQL/I-would-like-to-create-a-notebook-query-in-order-to-check-for/m-p/232561#M451</link>
      <description>&lt;P&gt;I want to monitor the&amp;nbsp;average lock time a specific service is experiencing using a DQL&amp;nbsp;query&lt;/P&gt;</description>
      <pubDate>Fri, 22 Dec 2023 07:32:51 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/DQL/I-would-like-to-create-a-notebook-query-in-order-to-check-for/m-p/232561#M451</guid>
      <dc:creator>SharonGellerTip</dc:creator>
      <dc:date>2023-12-22T07:32:51Z</dc:date>
    </item>
    <item>
      <title>Re: I would like to create a notebook query in order to check for the average lock time a specific service is experiencing</title>
      <link>https://community.dynatrace.com/t5/DQL/I-would-like-to-create-a-notebook-query-in-order-to-check-for/m-p/233285#M494</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/70112"&gt;@SharonGellerTip&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;It may be that the metric you are looking for might not be available in Grail as of yet you can allways check what we have available as built in metrics&amp;nbsp;&lt;A href="https://docs.dynatrace.com/docs/observe-and-explore/metrics/built-in-metrics-on-grail" target="_self"&gt;here&lt;/A&gt;&lt;/P&gt;&lt;P&gt;If you do find that the metric you are looking for is in that list then you can write some DQL like this to get the result you are looking for:&amp;nbsp;timeseries Lock_Time=avg(&amp;lt;metric_name&amp;gt;)&lt;/P&gt;&lt;P&gt;Here is an example of querying avg CPU consumption:&lt;/P&gt;&lt;P&gt;timeseries cpu=avg(dt.host.cpu.usage)&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="luke_hearth_0-1704300058380.png" style="width: 400px;"&gt;&lt;img src="https://community.dynatrace.com/t5/image/serverpage/image-id/16592iBE7F98013E151B2A/image-size/medium?v=v2&amp;amp;px=400" role="button" title="luke_hearth_0-1704300058380.png" alt="luke_hearth_0-1704300058380.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 03 Jan 2024 16:41:22 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/DQL/I-would-like-to-create-a-notebook-query-in-order-to-check-for/m-p/233285#M494</guid>
      <dc:creator>LukeHearth</dc:creator>
      <dc:date>2024-01-03T16:41:22Z</dc:date>
    </item>
  </channel>
</rss>

