Search

Top 60 Oracle Blogs

Recent comments

Oracle Database Cloud (DBaaS) Performance Consistency - Part 6

#333333; font-family: Verdana, Arial, sans-serif;">In the next parts of this series I'll have a look at the results of similar performance consistency tests performed on a comparable Amazon RDS Oracle cloud database instance.

#333333; font-family: Verdana, Arial, sans-serif;">
#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">Let's start with the configuration used, which was an Amazon RDS "#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">db.m4.2xlarge" instance - the latest RDS generation available at time of testing. This is an 8 VCPUs resp. Hyper Threads / 4 cores configuration with 32GB of RAM.
#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">As storage I've used the "General Purpose SSD" setup. Although there is a "Provisioned IOPS" configuration available, too, I haven't used for testing because according to the price calculator available it would have costed me several hundred dollar even for a very short period of testing because some part of the configuration gets charged per month, no matter how long I actually use it. I'll get back to that point when dealing with the I/O related tests and the raw performance figures.
#333333; font-family: Verdana, Arial, sans-serif;">Therefore I've only run the tests on the "General Purpose SSD" configuration - more on that in later installments.
#333333; font-family: Verdana, Arial, sans-serif;">Even without the "Provisioned IOPS" storage the tests were only conducted for several hours instead of several days, therefore they can't be compared #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">directly#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;"> #333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">to the other test results.
#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">The first test conducted was the "PL/SQL" CPU burning test I've outlined in the first part#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;"> of this series.
#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">The overall consistency result looked like this:
#333333; font-family: Verdana, Arial, sans-serif;">
#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">Again the graph is supposed to show how many of the runs deviated how much from the overall median runtime. The results - at least for the short period of the test run - are very consistent, similar to the other test results.
#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">Looking at the results on a more granular basis is only of limited use in this case due to the short test run time, hence the resolution is changed to hours instead of days here:
#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">There were a couple of hours that show a very similar behaviour and again another set of hours with rather a similar profile, and there is an hour with a rather unusual profile.
#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">Finally, looking at the runtime of the individual threads:
#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">Except for one threads all other show a very similar runtime, also the runtime is very consistent.
#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">It should be noted however, that the actual raw performance of each thread is pretty different from that of the Oracle DBaaS offering based on 4 OCPUs, because the DBaaS offering actually provides 8 cores, and hence scales much better when running with 8 threads - see the corresponding previous test results#333333; font-family: Verdana, Arial, sans-serif; font-size: 13px;">. The Amazon RDS raw performance is more comparable to that of the 4 cores physical host used in the previous tests for comparison.
#333333; font-family: Verdana, Arial, sans-serif;">