SAP Sync is slow (SAPLicence Table)

Dear All,

I can see that Standart SAP R/3 connector Step(licensetype) takes 40 minute to sync 312 Object. When I checked Indexes on SAPLicense Table, there are 4 indexes but every Index covered with one colum. As far as I can see, indexes can be improve. Is ist possible to improve Indexes and make it Sync time more short? (We are using revision filter) Also SAPLicense table has 312 entry for this SAP system.

This is not about hardware performance because as you can see in Screenshot, 26000 user sync in 42 minutes.

System: One Identity 9.1.1 Production and test are same.

Thank you in advance

Best regards

Samet

0 Andreas Finsterbusch 9 months ago

Your screenshot shows 40 and a half seconds for Step(licensetype).
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 samet guney 9 months ago in reply to Andreas Finsterbusch

Nope, total sync takes more then 2 hours. License 40 min, roles 50 min, users 45 min...
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Markus Weiss-Ehlers 9 months ago in reply to samet guney

But in your screenshot you can see that step 14. USERs took 42.85 minutes. Step 11. License type took 40.52 seconds.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 samet guney 9 months ago in reply to Markus Weiss-Ehlers

Oh now I can see that, thank you all.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel