Slow performance when running the Append Parcel Fabric geoprocessing tool with SQL Server.
Last Published: March 28, 2017ArcSDE/Enterprise Geodatabase
Bug ID Number
April 14, 2015
June 11, 2020
Operating System Version
This issue was not reproducible when tested by the development team. Issues may be given this status when they cannot be reproduced or are no longer relevant in a development version of the software, but a specific fix was not installed to address the issue. The issue's Additional Information section may contain further explanation.
At ArcGIS 10.5, feature classes you create in a geodatabase in SQL Server that use Geometry or Geography storage will store attributes such as pointIDs, multipatches, and parametric entities (such as true curves) directly in the business table.
Prior to ArcGIS 10.5, this information was stored in a side table that joined with the business table, and the join could cause poor performance if the side table contained lots of geometry attributes. This decreased performance was often noticed while working with parcel fabric datasets, for example.
Using a 10.5 client, you can run the Migrate Storage geoprocessing tool to migrate the geometry attributes into the business table and take advantage of performance improvements.
***Note that 10.3 and earlier clients cannot connect to feature classes that use this new type of storage.