| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Performance and Tuning Guide Volumes 1 - 3 (Online Only) |
![[-]](/dwicons/i_colpse.gif)
| Chapter 4 Distributing Engine Resources |
Chapter 4
This chapter explains how to assign execution attributes, how Adaptive Server interprets combinations of execution attributes, and how to help you predict the impact of various execution attribute assignments on the system.
Understanding how Adaptive Server uses CPU resources is a prerequisite for understanding this chapter.
For more information, see Chapter 3, "Using Engines and CPUs."
|
| Algorithm for successfully distributing engine resources |
| Algorithm guidelines |
![[+]](/dwicons/i_expand.gif)
| Environment analysis and planning |
| Performing benchmark tests |
| Setting goals |
| Results analysis and tuning |
| Monitoring the environment over time |
| Manage preferred access to resources |
|
| Types of execution classes |
| Predefined execution classes |
| User-Defined execution classes |
|
| Execution class attributes |
| Base priority |
| Time slice |
| Task-to-engine affinity |
|
| Setting execution class attributes |
| Assigning execution classes |
| Engine groups and establishing task-to-engine affinity |
|
| How execution class bindings affect scheduling |
| Setting attributes for a session only |
| Getting information |
|
| Rules for determining precedence and scope |
|
| Multiple execution objects and ECs |
| Resolving a precedence conflict |
| Examples: determining precedence |
|
| Example scenario using precedence rules |
| Planning |
| Configuration |
| Execution characteristics |
|
| Considerations for Engine Resource Distribution |
|
| Client applications: OLTP and DSS |
| Adaptive Server logins: high-priority users |
| Stored procedures: "hot spots" |
|
|