Question

Sync between 2 Enterprise GDB on SQL Server - performance delay with FME 2021.1

  • 8 February 2022
  • 3 replies
  • 16 views
V
Badge

I have synchronising the data between 2 (source & destination)enterprise GDB on SQL server (2 separate SQL Server virtual Nodes) both tables are non-versioned & archieved. My challenge is while synchronising the data into the destination table it's taking long time to writing, due to this it has huge performance delays.

For around 6600 records updating from Featureclass(A) from Enterprise GDB-A to Featureclass(B) from Enterprise GDB-B it's taking around 15-24 minutes.

 

I would like to reduce the time for wririntg the features into the destination table.(GDB tables are indexed and using by other usersthrough services & arcgis clientS)

 

You are assistance,advice or any piece of help is highly appreciated 

, @Takashi Iijima​ ,@david_r​ ,@theodrogo​ 

 

Regards

VIPLA

3 replies

M
Badge +2

@viplove555​ Scan through the article Improving Performance when working with Esri Geodatabases to see if that suggests any changes you can make. Performance Tuning FME might also help you find where the time is going in FME.

Also, where is FME relative to the data. If your ArcSDE is in the Cloud and FME is on premise then you may have network latency issues.

V
Badge

@viplove555​ Scan through the article Improving Performance when working with Esri Geodatabases to see if that suggests any changes you can make. Performance Tuning FME might also help you find where the time is going in FME.

Also, where is FME relative to the data. If your ArcSDE is in the Cloud and FME is on premise then you may have network latency issues.

Thanks Mark for the reply, we have followed the same weblinks for the FME performance tuning ( Performance Tuning FME ) . Only at the time of writing the data into the destination table is delaying . we checked Database table indexes as well. FME & SQL server both are in same subnet IP in MS Azure platform.

 

Is there any other way to decrease the time for writing the features into Enterprise GDB?

 

 

M
Badge +2

Thanks Mark for the reply, we have followed the same weblinks for the FME performance tuning ( Performance Tuning FME ) . Only at the time of writing the data into the destination table is delaying . we checked Database table indexes as well. FME & SQL server both are in same subnet IP in MS Azure platform.

 

Is there any other way to decrease the time for writing the features into Enterprise GDB?

 

 

@viplove555​ Possibly check that the FME TEMP is using a local drive on the FME Azure server. Ideally this would be an SSD drive but that might not be available on Azure. FME TEMP defaults to the user temp directory which might be on a network drive on Azure.

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.