Learn general guidelines for allocating RAPCache database CPU resources in a resource-constrained production environment.
Because of the unique nature of every RAP environment, it is impossible to provide a detailed procedure for assigning resources that makes sense for all systems. Here are some general guidelines:
-
Use the stored procedure sp_sysmon to identify the most resource-intensive activities.
-
Allocate engines to these activities.
For example, message loading and data truncation are the most resource intensive activities. Ideally, they require four engines each, however, you may allocate only two engines to each to get optimal performance within a limited resource environment.
-
Allocate remaining engines to the next-most resource-intensive activities until you run out of engines.
-
Share engines between the most resource-intensive activities and the least resource-intensive activities. In the table below, "Engine number" refers to the engine assigned to each activity.
| Activity |
Engine number |
|---|
| Message flow |
0, 1 |
| Derived-data generation |
4 |
| Derived-data modification |
2 |
| Data truncation |
3, 5 |
| Data transfer |
2 |
| Real-time market data analysis |
4 |