What are the issues of a DSS/OLTP environment?
When you add parallelism to a mixed DSS/OLTP environment, the goal is to improve DSS performance without adverse impact on OLTP performance. Some issues that you may need to address are: • Lock contention • Too few devices configured for tempdb • Procedure cache effects For details and remedies, see the section on system level impacts in chapter 13, Performance and Tuning Guide .
Related Questions
- In the OLTP environment, you should activate table clustering only if SAP Support recommends this for certain tables.25. Which tables in the OLTP environment are suitable for database clustering?
- Using a hybrid system, OLTP for day and DSS for night, what is the most efficient method of altering the parameters for day and night use?
- What is sustainability?
