Edit

Share via


Use the advanced hunting query resource report

Applies to:

  • Microsoft Defender XDR

Understand advanced hunting quotas and usage parameters

To keep the service performant and responsive, advanced hunting sets various quotas and usage parameters (also known as "service limits"). These quotas and parameters apply separately to queries run manually and to queries run using custom detection rules. Customers who run multiple queries regularly should be mindful of these limits and apply optimization best practices to minimize disruptions.

Refer to the following table to understand existing quotas and usage parameters.

Quota or parameter Size Refresh cycle Description
Date range 30 days for Defender XDR data unless streamed through Microsoft Sentinel Every query Each query can look up Defender XDR data from up to the past 30 days, or longer if streamed through Microsoft Sentinel
Result set 30,000 rows Every query Each query can return up to 30,000 records.
Timeout 10 minutes Every query Each query can run for up to 10 minutes. If it doesn't complete within 10 minutes, the service displays an error.
CPU resources Based on tenant size Every 15 minutes The portal displays a warning whenever a query runs and the tenant consumes over 10% of allocated resources. Queries are blocked if the tenant reaches 100% until after the next 15-minute cycle.

Note

A separate set of quotas and parameters apply to advanced hunting queries performed through the API. Read about advanced hunting APIs

View query resources report to find inefficient queries

The query resources report shows your organization's consumption of CPU resources for hunting based on queries that ran in the last 30 days using any of the hunting interfaces. This report is useful in identifying the most resource-intensive queries and understanding how to prevent throttling due to excessive use.

Access the query resources report

The report can be accessed in two ways:

  • In the advanced hunting page, select Query resources report:

    view the query resources report button in the AH portal

  • Within the Reports page, find the new report entry in the General section

    view the query resources report in the Reports section

All users can access the reports; however, only the Microsoft Entra Global Administrator, Microsoft Entra Security Administrator, and Microsoft Entra Security Reader roles can see queries done by all users in all interfaces. Any other user can only see:

  • Queries they ran via the portal
  • Public API queries they ran themselves and not through the application
  • Custom detections they created

Important

Microsoft recommends that you use roles with the fewest permissions. This helps improve security for your organization. Global Administrator is a highly privileged role that should be limited to emergency scenarios when you can't use an existing role.

Query resource report contents

By default, the report table displays queries from the last day, and is sorted by Resource usage, to help you easily identify which queries consumed the highest amount of CPU resources.

The query resources report contains all queries that ran, including detailed resource information per query:

  • Time – when the query was run
  • Interface – whether the query ran in the portal, in custom detections, or via API query
  • User/App – the user or app that ran the query
  • Resource usage – an indicator of the amount of CPU resources a query consumed (can be Low, Medium, or High, where High means the query used a large amount of CPU resources and should be improved to be more efficient)
  • State – whether the query was completed, failed, or was throttled
  • Query time – how long it took to run the query
  • Time range – the time range used in the query

Tip

If the query state is Failed, you can hover the field to view the reason for the query failure.

view inefficient queries

Find resource-heavy queries

Queries with high resource usage or a long query time can probably be optimized to prevent throttling via this interface.

The graph displays resource usage over time per interface. You can easily identify excessive usage and select the spikes in the graph to filter the table accordingly. Once you select an entry in the graph, the table is filtered to that specific date.

You can identify the queries that used the most resources on that day and take action to improve them – by applying query best practices or educating the user who ran the query or created the rule to take query efficiency and resources into consideration.

To view a query, select the three dots beside the timestamp of the query you want to check and select Open in query editor.

For guided mode, the user needs to switch to advanced mode to edit the query.

The graph supports two views:

  • Average use per day – the average use of resources per day
  • Highest use per day – the highest actual use of resources per day

Two view modes for query resources report

This means that, for instance, if on a specific day you ran two queries, one used 50% of your resources and one used 100%, the average daily use value would show 75%, while the top daily use would show 100%.

Tip

Do you want to learn more? Engage with the Microsoft Security community in our Tech Community: Microsoft Defender XDR Tech Community.