MaxDB / liveCache Performance on HP-UX

June 26, 2009 at 9:30 pm

[] [] [] [] [] [] [] [] [] [] [] [] []

Related:

  1. SAP on HP-UX: FAQSymptom This FAQ aims to answer the most commonly asked...
  2. Oracle installation on HP-UX 11.23 and 11.31Symptom After you call the /tmp/orainstRoot.sh. script, the Oracle Universal...
  3. MaxDB release for virtual systemsSymptom You want to use MaxDB/liveCache in virtual systems (VMware,...
  4. FAQ: SAP MaxDB OLTP cluster table attributeSymptom As of Version 7.6, SAP MaxDB provides the option...
  5. Feature list for liveCache/MaxDB 7.7Symptom This note provides an overview of the most important...
  6. Parameter check for liveCache/MaxDB instancesSymptom You want to use an automatic check to check...
  7. Parameter recommendations for OneDB systemsSymptom This note provides recommendations regarding configuration parameter settings for...

Symptom

- You want to optimize performance of your MaxDB or liveCache system running on HP-UX
- You are experiencing MaxDB/liveCache performance bottlenecks as described below and want to improve the situation
Other terms

HP-UX, 11.11, 11.23, 11.31, 11i, 11iv1, 11iv2, 11iv3, liveCache, MaxDB, performance
Reason and Prerequisites

The HP-UX 11.31 OS (Operating System) has been significantly optimized to improve the performance of highly parallelized multithreaded applications, such as SAP MaxDB and LiveCache.
If your system matches the following criteria, then upgrading the OS to HP-UX 11.31 is very likely to help:
- Relatively low MaxDB/liveCache throughput during high workload periods
- High OS System Time for MaxDB/liveCache “kernel” process
- Server is running an HP-UX Version older than 11.31 (e.g. 11.11 and 11.23)
- Server has >= 4 CPU Cores
- The HP Tool “glance” shows the system calls “kwakeup()” and “sched_yield()” dominating system time

If you are not sure whether your system matches the above criteria, please contact MaxDB/liveCache support for advice.
Solution

Upgrade OS to HP-UX 11.31 (Patch Level >= “0803″ [March 2008] )

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

Leave a Comment