David Wein is a well known and highly respected engineer at Sybase working on Adaptive Server Enterprise. I’m reposting his blog article here to help increase the exposure of his request for comments:
I am working on a future version of ASE and am interested in hearing about your experiences with the logical process manager (LPM). LPM consists of engine groups and execution classes, as well as the ability to set spid priority in an ad-hoc manner via sp_setpsexe. This functionality is sometimes referred to as application queues.
If you have used this feature I’d like to know:
- What was the use case (in other words, why did you use it)?
- What elements did you use? How did you use it?
- Did it meet your needs? Did you run into problems?
- Any shortcomings or requirements that weren’t met?
- What was your overall impression?
If you evaluated the functionality but chose not to use it, please let me know what you were trying to accomplish and why you decided against using LPM.
Finally, if you have use cases or requirements around managing multiple applications in a single ASE server, or managing the priority / resources of specific spids, please pass those along. Unaddressed use cases are extremely useful to hear about.
Please provide your feedback directly to me at email@example.com, and include “logical process manager feedback” in the mail subject (I get a lot of mail and this will help make sure I don’t miss your mail!). Please be as detailed and specific as you can about your use cases and results.
Thanks a bunch,
Let’s help Dave, and ourselves, out by giving him our experiences with the logical process manager. Please be descriptive as “it sucks” or “it’s great” doesn’t really help.
If anyone wants to post their experiences to this blog post, that’s okay too. I’ll forward any comments to Dave.