Fusion-io has announced that its VSL software subsystem and four 1.2 TB Fusion ioDrive2s in a single 64-core AMD server reached 1.11 million transactions per second in a Microsoft SQL Server database test. This data throughput was the projected requirement to run all credit card transactions on the planet, reaching a new level of powering efficiency in retail data processing during the retail’s busiest time of the year.
Fusion-io has announced that its VSL software subsystem and four 1.2 TB Fusion ioDrive2s in a single 64-core AMD server reached 1.11 million transactions per second in a Microsoft SQL Server database test. This data throughput was the projected requirement to run all credit card transactions on the planet, reaching a new level of powering efficiency in retail data processing during the retail’s busiest time of the year.
Thomas Kejser, SQL Server Customer Advisory Team, believes that in order to take advantage of the growing popularity of the NAND flash industry, IT professionals need to understand how they build their systems. “For example,” Kejser states, “Low latency architecture that uses NAND flash as part of the memory hierarchy helps avoid bottlenecks by integrating close to the CPU for low latency application performance, which is why Fusion-io was selected for this high scale demonstration."
During the demonstration, inserts were completed on 150 billion wide rows into a single database table in Microsoft SQL Server. This resulted in 1.1 million singleton inserts per second figure while the update statements demo achieved 2.5 million updates per second using the same test. One transaction equates to one debit, one credit, and one update of account balance, which, when applied to daily transaction requirements, amounts to approximately 25 billion simplified transactions per day. This amount is equivalent to every single credit card transaction that is made daily on the entire planet from now until 2050, when earth’s population is predicted to reach 9 billion people.
