Calculation using two measure time values in iterations returns negative values in SQL Server 2012, 2014, or 2016

Gilt für: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise Mehr

Symptoms


Assume that you have two measure times, T1 and T2, and T2 is greater than T1. If you calculate (T2-T1) in many iterations, the results might be incorrect. For example, the results might be negative values.

Resolution


This problem was first fixed in the following 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 Microsoft uses to describe software updates.