FIX: It may take longer than expected to create a SQL Server LineString instance in SQL Server 2014 SP1

To enable the new behavior, enable the SQL Server trace flag 6534.

The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 8 for SQL Server 2012 SP2

Cumulative Update 9 for SQL Server 2014

Cumulative Update 1 for SQL Server 2014 SP1

About cumulative updates for SQL Server

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
More information
The Microsoft.SqlServer.Types objects support Microsoft SQL Server Spatial data types for the SQL Server service and the client applications. The logic to populate a LineString object involves validation. The validation logic sorts vertices during the validation. The more vertices, the more work for the algorithm. This fix updates the sorting algorithm to include angular vectorization techniques that significantly improve the LineString performance.

You can enable the new algorithm in client code:
AppDomain.CurrentDomain.SetData("clr_feature_switch_map", 1);
Note This should only be set for one time. A crash may occur when you change it during the validation.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Article ID: 3054180 - Last Review: 09/22/2015 02:30:00 - Revision: 5.0

Microsoft SQL Server 2014 Service Pack 1, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Standard

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced KB3054180