ESPs and performance

Since both Adaptive Server and XP Server reside on the same machine, they can affect each other’s performance when XP Server is executing a function that consumes significant resources.

You can use sp_configure to set two parameters, esp execution priority and esp unload dll, to control the impact of XP Server on Adaptive Server by setting priorities for ESP execution and by freeing XP Server memory.