Tuning 3rd party databases is not what I’d like to spend time on, but this Citrix database keeps deadlocking on this procedure: chb_Config.chb_UpsertLeases.
This was resolved by adding included columns to the index, to avoid a bookmark lookup.
CREATE UNIQUE NONCLUSTERED INDEX [IX_Leases_LeaseKey]
ON [chb_State].[Leases]( [LeaseKey] ASC)
INCLUDE ( [IsMarkedForDeletion], LeaseChecksum, UserUid, LastModifiedTime)
WITH (DROP_EXISTING = ON)