Hi All,
I just upgraded to 10.4 and have noticed that various parcel fabric tools/dialogs are taking a very long time to load and process in side-by-side comparison to a 10.3.1 machine. Our fabric is in SQL Server 2014. I have updated the stored procedures on the database and the performance issues remain.
The Duplicate dialog takes about 45 seconds to display and another 55 seconds to duplicate a single parcel. The parcel division dialog displays find but the process to split a single parcel into 2 pieces takes about a minute.
Are there any tips for migration that might help?
Thanks,
Mike
Hi Mike,
There's a section in the What's New at 10.4 doc, that may help to solve your problem:
To use ArcGIS 10.4 with SQL Server databases or 10.3.1 or
earlier release geodatabases, you must manually set on READ_COMMITTED_SNAPSHOT
in the database.
Tim,
I am able to run queries to get these properties and they are both on (1) for 'is_read_committed_snapshot_on' and 'snapshot_isolation_state' properties.
Mike
Mike,
Thanks again for reporting this, and for sharing your data via tech support. I'm responding again here to share findings with other customers who may have experienced similar issues with SQLServer. The delay was caused by a combination of 2 things: some changes made to the cursor model for 10.4 on SQLServer, and the Uncommitted records (Status=0) in the jobs table. The latter records are accumulated when editing directly against default, instead of in a version. We recommend editing in a version since posting the version will automatically commit the job for you (Status=1). If there is a need to edit directly on default, then after the edit we'd recommend manually committing the job afterwards.
To clear out the jobs table, you can un-register the fabric as versioned, then use the Delete Fabric Records add-in 's Truncate command to "Drop all fabric jobs"
-Tim