10.4 Parcel Fabric の処理がかなり遅くなっています

Question

<\/HEAD>皆さん、こんにちは、<\/P> <\/P> 私は最近 10.4 にアップグレードしましたが、さまざまな parcel fabric ツールやダイアログの読み込みと処理に非常に長い時間がかかっていることに気付きました。これは 10.3.1 のマシンと並べて比較した場合です。私たちの fabric は SQL Server 2014 上にあります。データベースのストアドプロシージャは更新しましたが、パフォーマンスの問題は解消されていません。<\/P> <\/P> Duplicate ダイアログの表示には約45秒かかり、単一の parcel を複製するのにさらに55秒かかります。parcel division ダイアログは正常に表示されますが、単一の parcel を2つに分割する処理には約1分かかります。<\/P> <\/P> 移行時に役立つヒントはありますか？<\/P> <\/P> ありがとうございます。 Mike<\/P><\/BODY><\/HTML>

TimHodson · Answer

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

MichaelSnook · Answer

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

TimHodson · Answer

Hi Mike,

There's a section in the What's New at 10.4 doc, that may help to solve your problem:

http://desktop.arcgis.com/en/arcmap/latest/get-started/introduction/whats-new-in-arcgis.htm#GUID-BFAB27B8-04AA-4C21-90D0-C63B7A7A4E59

* Beginning with ArcGIS 10.4, geodatabases in SQL Server
     require the SQL Server database options READ_COMMITTED_SNAPSHOT and
     ALLOW_SNAPSHOT_ISOLATION be set to ON. When you upgrade your geodatabase
     in SQL Server, the Upgrade Geodatabase tool sets these in the database.
     When you create a geodatabase in SQL Server using the Create Enterprise
     Geodatabase tool, the tool sets these options in the database. If you use
     the Enable Enterprise Geodatabase tool to create a geodatabase, you must
     either set these options to ON in the database before you run the tool, or
     grant the geodatabase administrator the permission to ALTER the database.
     If the geodatabase administrator has ALTER database permission, the Enable
     Enterprise Geodatabase sets READ_COMMITTED_SNAPSHOT and
     ALLOW_SNAPSHOT_ISOLATION to ON in the database.

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.