• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Reader Feedback On One Power 750 Matches Two Xeon Servers On SAP BW Test

    September 23, 2013 Timothy Prickett Morgan

    You write:

    “The database IBM tested had 500 million records, which could fit into a machine with 32 cores; I am guessing here, but it would probably take a 64-core machine to do 1 billion records as HP tested with its pair of ProLiant DL580 G7 servers.”

    What does the number of DB records have to do with the number of cores required? I’m not aware of any correlation between the two. Perhaps you were thinking of a correlation between DB records and RAM (only applies to in-memory databases; not IBM i).

    “The HANA database has data compression and columnar data store, which is why it can get a fat database into the 512 GB of main memory.”

    Something about that sounds fishy. Wouldn’t the data have to be uncompressed in order for queries to perform relational operations against column values?

    Data may be compressed while stored persistently, but wouldn’t it be decompressed when loaded into RAM?

    “With the ProLiant DL580 G7 database server running at 88 percent of CPU and the app server linked to it running at 28 percent of CPU (which suggests some bad sizing if you are worried about wasting money).”

    Maybe HP was more concerned about increasing throughput than wasting money. There’s generally a strong correlation between the number of app server instances running and the number of cores, because most operating systems (other than IBM i) require significant resources just to do task switching. The cores may be idle, but you still need them to avoid task switching.

    That also explains why you see vendors dividing database workloads and app server workloads across two physical or virtual machines. Running complex workloads wreaks havoc on benchmarks results under most operating systems.

    Do you see how remarkable it is that both database and app server workloads ran so well on a single IBM i partition?

    –Nathan

    Well, I did see that, and I pointed it out! HA!

    As for the questions you bring up, they are good ones and I am working to try to get answers. Provided Hewlett-Packard and SAP want to enlighten us, I will report back.

    –TPM

    RELATED STORIES

    One Power 750 Matches Two Xeon Servers On SAP BW Test

    Power 750 Servers Running i Get SAP Benchmarks

    Power Systems Performance: First Up, SAP BI Data Mart

    The System i Still Owns the SAP BI Data Mart Benchmark

    Power6-Based System i Performance: Your Mileage Will Vary

    The i5 Shows Linear Scalability on SAP Benchmark

    The i5 Tests Well on SAP Data Warehousing Benchmarks



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Racksquared

    It’s time for IBM Power in the Cloud!

    Stop buying hardware and make the move to the cloud. It’s easier and more cost effective than you might think.

    • IBM Power in the Cloud
    • IBM Power Backup Solutions
    • IBM Power High Availability and DR solutions
    • IBM Power Colocation with Management and Monitoring

    Let’s talk about your business needs.

    Call: 855-380-7225

    Email: Sales@racksquared.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Kwik Trip Stops at RJS for Doc Management Raz-Lee Delivers New IFS Object Security for IBM i

    Leave a Reply Cancel reply

Volume 23, Number 32 -- September 23, 2013
THIS ISSUE SPONSORED BY:

Bug Busters Software Engineering
New Generation Software
BCD
Linoma Software
RJS Software Systems

Table of Contents

  • The Possibilities With IBM i Entry Systems Sporting Power8
  • PureSystems Anyone?
  • IBM i Jobs: Having What It Takes To Get Hired
  • As I See It: In Search of the Technology-Free Vacation
  • IBM i To Ride The Coattails Of Linux On Power
  • Reader Feedback On One Power 750 Matches Two Xeon Servers On SAP BW Test
  • IBM Nabs Daeja, Gets Browser-Based Image Viewer
  • COMMON’s Fountain of Youth
  • IBM i Advocate Ian Jarman To Keynote At RPG & DB2 Summit
  • Age Does Not Divide Social Media Users

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Power Systems Did Indeed Grow Revenues Last Year
  • The IBM Power Trap: Three Mistakes That Leave You Stuck
  • Big Blue Decrees Its 2023 IBM Champions
  • As I See It: The Good, the Bad, And The Mistaken
  • IBM i PTF Guide, Volume 25, Number 5
  • N2i Gains Traction Among IBM i Newbies
  • Realizing The Promise Of Cross Platform Development With VS Code
  • 2023 IBM i Predictions, Part 3
  • Four Hundred Monitor, January 25
  • Join The 2023 IBM i Marketplace Survey Webinar Tomorrow

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2022 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.