Performance and latency of Analytics

Azure DevOps Services | Azure DevOps Server 2022 - Azure DevOps Server 2019

When you use Analytics for reporting, you should understand data latency and query performance. To get started using Analytics, see what is the Analytics.

Note

The Analytics service is automatically enabled and supported in production for all Azure DevOps Services. Power BI integration and access to the OData feed of the Analytics Service are generally available. We encourage you to use it and give us feedback. Available data is version-dependent. The latest supported version is v2.0, and the latest preview version is v4.0-preview. For more information, see OData API versioning.

Note

The Analytics service is automatically installed and supported in production for all new project collections for Azure DevOps Server 2020 and later versions. Power BI integration and access to the OData feed of the Analytics Service are generally available. We encourage you to use it and give us feedback. If you upgraded from Azure DevOps Server 2019, then you can install the Analytics service during upgrade.

Available data is version-dependent. The latest supported version is v2.0, and the latest preview version is v4.0-preview. For more information, see OData API versioning.

Note

The Analytics service is in preview for Azure DevOps Server 2019. You can enable or install it for a project collection. Power BI integration and access to the OData feed of the Analytics Service are in Preview. We encourage you to use it and give us feedback.

Available data is version-dependent. The latest supported version is v2.0, and the latest preview version is v4.0-preview. For more information, see OData API versioning.

Install or enable Analytics

When you enable or install Analytics for a project collection, expect the initial setup to take between 5 and 30 minutes. After 24 hours, if you aren't able to access your data, contact Microsoft Support.

Data latency

When you use Analytics, you query a curated copy of the data stored in Azure DevOps. The data copy helps optimize read and aggregation performance, and greatly reduces the effect reporting scenarios have on Azure DevOps.

Because the data is copied, Analytics is not a real-time time store. Copying the data introduces up to a 30-second delay before the data associated with any one change shows up in Analytics.

Query performance

Using the recommended query patterns, Analytics will respond to any aggregation or non-aggregated query query within 3 to 5 seconds. The query response will be paged if it exceeds 10,000 results.

Some of the entity sets available in Analytics are designed for aggregations. The service will limit the results from these Entities to a single page for any non-aggregated query as outlined in the recommended query patterns.