Performance Tuning The OpenEdge Database In The Modern World
Performance Tuning the OpenEdgeDatabase in The Modern WorldGus Björklund, ProgressMike Furgal, Bravepoint
Performance tuning is not onlyabout software configurationand turning knobs
Situation:Your server is 5 years oldVendor is raising supportfees to get rid of old systemsWhat do you buy as areplacement ?
Hardware is cheap
Your new server will have:ProcessorsMemoryStorageSoftware
CPUs
Modern processors are very fastSingle CPU machineshardly exist anymoreYou can have way more CPUpower than you can ever use
Simple Single Processor Architecture One Level High Speed Cache MemoryProcessorCacheMemory BusMain Memory
Multi-Processor cheCacheCacheCacheMemory BusMain Memory
A technique to avoidCache Coherency issuesLessen the number ofprocesses connecteddirectly to shared memory
Main Memory
How Much Memory Does 100 Buy?Memory prices have droppedsignificantly over the pastyears. For example in theyear 2000, 64 MB of memorycost 100. In 2010 for 100you could get 4 GB ofmemory. Today (2014) thatsame 100 gets you about16 GB of 98200320082013
Main MemoryThe least expensive wayto enhance performanceBuy as much as you can
NUMA
NUMA Stands for Non-Uniform Memory AccessIn layman's terms, a NUMAmachine is the coupling ofseveral machines in a singlephysical unit, running a singleOperating System. Like a"cluster" (if you squint)
The NUMA QuotientThis is the time it takes for aCPU to read memory on aremote node as compared toreading memory locally
How Do You Know if You Have a NUMA Machine?
So now you know youhave a NUMA machineIs all hope lost?
On some machines you can pin memoryand processes to a particular nodeOn some you can disable nodesbut may lose memory tooBottom line – don’t buy a NUMA machine
Storage
RAID
RAIDWhy?
RAID 0: disk stripingperformance but NO reliability
RAID 1: disk mirroringreliability – two copies
RAID 5: disk striping with parityreliability and bad performanceall writes update 2 drives
RAID 6: disk striping with two parity disksreliability and worse performanceall writes update 3 drives
RAID (Redundant Arrays of Inexpensive Disks)Type32DescriptionUse?RAID 0Block striping (no redundancy at all)BadRAID 1MirroringOKRAID 10Block striping mirroringExcellentRAID 2Bit level striping, dedicated parityBadRAID 3Byte level striping, dedicated parityBadRAID 4Block striping, dedicated parityBadRAID 5Block striping with striped parityPoorRAID 6Block striping with dual striped parityPoorRAID 60, 6 , DP, etc.MarketingPoor 2014 Progress Software Corporation. All rights reserved.
RAID (Redundant Arrays of Inexpensive Disks)TypeDescriptionUse?RAID 0Block striping (no redundancy at all)BadRAID 1MirroringOKRAID 10Block striping mirroringExcellentRAID 2Bit level striping, dedicated parityBadRAID 3Byte level striping, dedicated parityBadRAID 4Block striping, dedicated parityBadRAID 5Block striping with striped parityPoorRAID 6Block striping with dual striped parityPoorRAID 60, 6 , DP, etc.MarketingPoor Advancements in technology can never make a silk purse from the RAID 5 sow's ear Local disks beat SAN storage33 2014 Progress Software Corporation. All rights reserved.
SSD
SSD Prices have dropped – a LOT. Low end is 0.50 per gigabyte Reliability is now very good – better than spinning rust SSD devices are fast, and getting faster Use Mirrorred pairs – NO RAID 5 When you need to replace one, you may not be able to get matchingunits anymore Fetching a record that is already in the database buffer pool is 75 timesfaster than SSD !!!!37 2014 Progress Software Corporation. All rights reserved.
Time to Grow a 96 MB FileDisk TypeDurationSpeedSpinning Disk7–109–13 MB/SecSSD1–243–96 MB/Sec
in Big B You Should Trust!LayerTime# of Recs# of OpsCost per OpRelativeProgress to –B0.96100,000203,4730.0000051-B to FS Cache10.24100,00026,7110.00038375FS Cache to SAN5.93100,00026,7110.00022245-B to SAN Cache*11.17100,00026,7110.000605120SAN Cache to Disk200.35100,00026,7110.0075001500-B to Disk211.52100,00026,7110.0079191585* Used concurrent IO to eliminate FS cacheCourtesy of Tom Bascom39 2014 Progress Software Corporation. All rights reserved.
Mid-range serverreplacement example
NameQuantityValueCPU4Intel Xeon E5 4603, 8 coresRAM81866MT/s 4 GB RDIMMEther1Intel GB Ethernet CardDisk Controller1PERC H10Storage, hot plug8146 GB 15,000 rpm SASStuff?dual psu. case, etc.Operating system1Linux, not included
Modern OpenEdge RDBMS
Advanced Tuning Techniques
Get CurrentBetter be on 10.2B08 or later
-lruskips
-B2
Client Database-Request Statement CachingProcedure Call Stack Top is last procedure executed One time full stack Bottom is first procedure executed Continuous full stack Top down, newest to oldest Continuous current location#TopNewestOldestProcedure Name19: reallyLongNamedInternalProcedure3proctestb.r12: reallyLongNamedInternalProcedure2proctestb.r5: reallyLongNamedInternalProcedure1proctesta.r445: reallyLongNamedInternalProcedure0proctesta.r1: /usr1/stmtest/p72340 Untitled1.pedBottom53File Name 2014 Progress Software Corporation. All rights reserved.
table partitioning
index rebuild
Index Rebuild Performance (OE 10.2B06, OE 11.2)-TB64-datascanthreads# threads for data scan phase1.5 X #CPUs-TMBmerge block size ( default -TB)64-TFmerge pool fraction of system memory (in %)80%-mergethreads# threads per concurrent sort group mergingX -threadnum 1.5 X#CPUs-threadnum-TM-rusage-silent56sort block size (8K – 64K, note new limit)# concurrent sort group merging# merge buffers to merge each merge passreport system usage statisticsa bit quieter than before 2014 Progress Software Corporation. All rights reserved.2 or 432-rusage-silent
Index Rebuild Performance (OE 10.2B06, OE 11.2)-TB-datascanthreads-TMB-TFsort block size (8K – 64K, note new limit)64# threads for data scan phasePUsmerge block size ( defmerm 1.5 X#CPUs2 or 4ge each merge passreport system usage statistics-silent57a bit quieter than before 2014 Progress Software Corporation. All rights reserved.32-rusage-silent
-omsize
How to Manage Object Mapping Cache Do I have a problem?define variable prev-latches as integer.repeat:find latch where latch-name "MTL OM".display Latch-NameLatch-Lock /* # times latch acquired */Latch-Wait /* # time conflict occurred */Latch-Lock - prev-latches label "latch/sec".prev-latches Latch-Lock.pause 1.end.59 2014 Progress Software Corporation. All rights reserved.
The dawn rises only whenthe rooster crows.– Burmese proverb
m
Visit the Resource Portal Get session details & presentation downloads Complete a survey Access the latest Progress product literaturewww.progress.com/exchange2014
Performance Tuning the OpenEdge Database in The Modern World . Gus Björklund, Progress . Mike Furgal, Bravepoint . Performance tuning is not only about software configuration and turning knobs . Situation: Your server is 5 years old . Vendor is raising support fees to get rid of old systems .
May 02, 2018 · D. Program Evaluation ͟The organization has provided a description of the framework for how each program will be evaluated. The framework should include all the elements below: ͟The evaluation methods are cost-effective for the organization ͟Quantitative and qualitative data is being collected (at Basics tier, data collection must have begun)
Silat is a combative art of self-defense and survival rooted from Matay archipelago. It was traced at thé early of Langkasuka Kingdom (2nd century CE) till thé reign of Melaka (Malaysia) Sultanate era (13th century). Silat has now evolved to become part of social culture and tradition with thé appearance of a fine physical and spiritual .
including OpenEdge 10.x, OpenEdge 11.0, OpenEdge 11.1, and OpenEdge 11.2. *** There were a couple of issues observed during recent certifications of OE 11.3.2 3
On an exceptional basis, Member States may request UNESCO to provide thé candidates with access to thé platform so they can complète thé form by themselves. Thèse requests must be addressed to esd rize unesco. or by 15 A ril 2021 UNESCO will provide thé nomineewith accessto thé platform via their émail address.
̶The leading indicator of employee engagement is based on the quality of the relationship between employee and supervisor Empower your managers! ̶Help them understand the impact on the organization ̶Share important changes, plan options, tasks, and deadlines ̶Provide key messages and talking points ̶Prepare them to answer employee questions
Dr. Sunita Bharatwal** Dr. Pawan Garga*** Abstract Customer satisfaction is derived from thè functionalities and values, a product or Service can provide. The current study aims to segregate thè dimensions of ordine Service quality and gather insights on its impact on web shopping. The trends of purchases have
When you log into OpenEdge View, we send you an email with a security code to the email address associated with your OpenEdge View user profile. When you enter the security code, you can choose to remember the browser. As long as you don't delete your browsing data, OpenEdge View won't ask you for a security code for 45 days.
Screw-Pile in sand under compression loading (ignoring shaft resistance) calculated using Equation 1.5 is shown in Figure 3. The influence of submergence on the calculated ultimate capacity is also shown. The friction angle used in these calculations is the effective stress axisymmetric (triaxial compression) friction angle which is most appropriate for Screw-Piles and Helical Anchors. 8 .
