Manage routing diagnostics data

The diagnostics data for unified routing is stored in Dataverse for Apps Database Capacity. We recommend that you periodically delete the routing diagnostics data to manage the storage capacity.

You can use the information in this section to define an effective strategy to manage your diagnostics data.

The following table lists the analysis of the average data consumption of some of our large customer organizations. The values are based on the assumption that each stage has one ruleset only.

Data consumption Size/Record in kilobytes (average) Description
Data consumed per ruleset within a diagnostic work item 13.271 The average data that's consumed by a single ruleset in a routing stage for the diagnostics item generated for a routed work item.
Data consumed per diagnostics work item 53.08 The average data consumed by the diagnostics item that's generated for a routed work item.

1 The average values can vary based on factors, like the number of rules, conditions defined within a ruleset, and size of the conditions (number of characters).

Let's take an example in which each routing stage has a single ruleset with a couple of rules and moderately complex rule conditions. If you route 500 work items per day, it generates 500 diagnostics work items that consume approximately 25.64 MB of data. For information about routing stages, see Understand routing stages.

Delete routing diagnostics data

Note

We recommend that you do the following actions before you perform the delete operation:

  • Verify and ensure that the data isn't required because delete operations are irreversible.
  • Turn off the diagnostic feature.
  1. Perform the steps in the Capacity page details article to view the storage consumption of the diagnostics records mentioned in step 2.

  2. Perform the steps in the Use bulk deletion to remove large amounts of data article to delete the following routing diagnostics data in the specified order.

    1. Search for "Routing diagnostic items" for the msdyn_unifiedroutingdiagnostic entity. More information: msdyn_unifiedroutingdiagnostic

      Screenshot of bulk delete action for routing diagnostics records.

    2. Search for "Routing diagnostics" for the msdyn_unifiedroutingrun entity. More information: msdyn_unifiedroutingrun

Next steps

View diagnostics for routed records