FIX: Queries on Stretch Database enabled databases always involves a network round-trip to Azure in SQL Server 2016

Symptoms

When you run a query that queries data from a table or a database that has Stretch Database enabled, the query always involves a network round-trip to the remote data on the Azure storage.

Resolution

The issue was first fixed in the following cumulative update of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology that Microsoft uses to describe software updates.
Properties

Article ID: 3174812 - Last Review: Sep 22, 2016 - Revision: 1

Feedback