Performance and latency of the Analytics Service

Azure DevOps Services | Azure DevOps Server 2019

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

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 is in Preview. 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 the Analytics Service by installing the Analytics Marketplace extension. Installing it 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 the Analytics Service

When you install the Analytics Marketplace Extension, 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, the Analytics Service 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, the Analytics Service 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.