Event 41 often indicates that multiple processes are simultaneously attempting to update rows on a single page.
Adaptive Server uses a latch as a transient lock to guarantee a page’s contents are not changed while another process reads or writes data. Adaptive Server typically uses latches in data-only locked tables to protect the contents of the page when multiple processes are simultaneously reading or updating rows on the same page. If one process attempts to acquire a latch while another process already holds the latch, the first process may need to wait. If event 41 occurs frequently, it may indicate a high level of contention for data on a single physical page within an index or table.
Reduce contention by:
Introducing an index with a sort order that distributes data differently across pages, so it spreads the rows that are causing contention
Changing your application so that such contention does not occur
