Performance and latency of Analytics

Azure DevOps Services | 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 generally available for all organizations using Azure DevOps Services. It provides several advanced widgets.

Power BI integration and access to the OData feed of the Analytics Service are in Preview. It is supported for use in production. We encourage you to use it and provide us feedback. As we add features, we will post them on the Microsoft DevOps Blog.

If you are looking for information about Azure Analysis Services, see Azure Analysis Services.

Note

The Analytics service is in preview for Azure DevOps Server 2019. While in preview, it is available to everyone free of charge. We encourage you to use it and provide us feedback. As we add features, we will post them on the Microsoft DevOps Blog.

You access Analytics by enabling or installing it for a project collection. The Analytics service provides several advanced widgets, Power BI integration, and access to the OData feed.

If you are looking for information about Azure Analysis Services, see Azure Analysis Services.

Install or enable Analytics

When you enable or install Analytics for a project collection, you should expect the initial setup to take between 5 to 30 minutes. If after 24 hours 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 impact reporting scenarios have on Azure DevOps.

Because the data is copied, Analytics is not a real-time time store. Copying the data introduces a 5 to 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.