ESPs and permissions  Setting priority

Chapter 17: Using Extended Stored Procedures

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.





Copyright © 2005. Sybase Inc. All rights reserved. Setting priority

View this book as PDF