1. Use custom sync queries for users and computers

You can modify the User ID and Computer ID sync queries to only include records created within the last 24 hours. This reduces the number of records processed during each sync.

Custom user ID sync query

IF DATENAME(weekday, GETDATE()) IN (N'Saturday', N'Sunday')

    SELECT vru.ResourceID AS UserResourceID FROM v_R_User vru ORDER BY vru.Name0

ELSE

    SELECT vru.ResourceID AS UserResourceID

    FROM v_R_User vru

    WHERE vru.Creation_Date0 >= DATEADD(day, -1, GETDATE())

    ORDER BY vru.Name0;

Custom computer ID sync query



IF DATENAME(weekday, GETDATE()) IN (N'Saturday', N'Sunday')

    SELECT vrs.ResourceID

    FROM v_R_System vrs

    WHERE vrs.Netbios_Name0 IS NOT NULL

    ORDER BY vrs.Netbios_Name0;

ELSE

    SELECT vrs.ResourceID

    FROM v_R_System vrs

    WHERE vrs.Creation_Date0 >= DATEADD(day, -1, GETDATE())

      AND vrs.Netbios_Name0 IS NOT NULL

    ORDER BY vrs.Netbios_Name0;

These queries run a full sync on weekends and a delta sync Monday through Friday, allowing older records to be updated during off-peak hours.

For more information about entering custom sync queries, refer to the Entering Common Deployment Technology Settings section of the App Portal Administration Guide.

2. Increase the sync page size

You can further reduce sync time by adjusting the sync page size:

• Navigate to the Common tab in the Administration settings.
• Set the Sync Page Size to a value between 5,000 and 10,000 records.

This change increases the number of records processed per batch during synchronization. You can learn more about this setting in Common Tab.

3.  Restart the ESD service

After applying any changes to sync queries or page size:

1. Restart the Flexera ESD Service on the App Portal server.
2. Confirm that sync operations resume as expected with improved performance.