• Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

Fusion-io Runs Equivalent of All Global Credit Card Transactions from a Single Server

btarunr

Editor & Senior Moderator
Staff member
Joined
Oct 9, 2007
Messages
46,277 (7.69/day)
Location
Hyderabad, India
System Name RBMK-1000
Processor AMD Ryzen 7 5700G
Motherboard ASUS ROG Strix B450-E Gaming
Cooling DeepCool Gammax L240 V2
Memory 2x 8GB G.Skill Sniper X
Video Card(s) Palit GeForce RTX 2080 SUPER GameRock
Storage Western Digital Black NVMe 512GB
Display(s) BenQ 1440p 60 Hz 27-inch
Case Corsair Carbide 100R
Audio Device(s) ASUS SupremeFX S1220A
Power Supply Cooler Master MWE Gold 650W
Mouse ASUS ROG Strix Impact
Keyboard Gamdias Hermes E2
Software Windows 11 Pro
Fusion-io recently announced that its VSL software subsystem and four 1.2 TB Fusion ioDrive2s integrated into a single 64-core AMD Server were able to achieve 1.11 million transactions per second in a Microsoft SQL Server database. The demonstration delivered the data throughput projected to be required to run all credit card transactions on the planet, underlining new solutions for powering efficiency in retail data processing as the 2011 holiday shopping season kicks off with record sales.

"Today's modern CPUs cannot be fed data fast enough with old approaches to application architecture," said Thomas Kejser, SQL Server Customer Advisory Team enterprise database specialist. "To fully leverage the possibilities of the NAND flash revolution in a way that utilizes the hardware, IT professionals need to understand the properties of what we use to build our systems. For example, 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."



In the demonstration, inserts were done on 150 billion wide rows, into a single database table in Microsoft SQL Server, ultimately resulting in 1.1 million singleton inserts per second figure. The same test was run with update statements, achieving 2.5 million updates per second. Translating this throughput number to simplified credit card transactions, using the system in the testing, one transaction is one debit, one credit, and one update of account balance. When applied to daily transaction requirements, this amounts to approximately 25 billion simplified transactions per day. To put the transaction number into perspective, this is equivalent to all the credit card transactions projected to be made daily by every individual on the planet from now until 2050, when it is expected that the world will be inhabited by nine billion people.

"Given how consumers are embracing online shopping, especially on Cyber Monday and even Black Friday, we believe this achievement showcases how Fusion-io can help meet demand for servicing more digital transactions with an efficient, rapid and reliable solution," said Neil Carson, Fusion-io Chief Technology Officer. "The transaction rates achieved in these tests demonstrate the high scalability and efficiency of today's Microsoft SQL Server databases when powered by Fusion-io."

For more information, visit the Fusion-io website.

View at TechPowerUp Main Site
 

de.das.dude

Pro Indian Modder
Joined
Jun 13, 2010
Messages
8,756 (1.74/day)
Location
Stuck in a PC. halp.
System Name Monke | Work Thinkpad| Old Monke
Processor Ryzen 5600X | Ryzen 5500U | FX8320
Motherboard ASRock B550 Extreme4 | ? | Asrock 990FX Extreme 4
Cooling 240mm Rad | Not needed | hyper 212 EVO
Memory 2x16GB DDR4 3600 Corsair RGB | 16 GB DDR4 3600 | 16GB DDR3 1600
Video Card(s) Sapphire Pulse RX6700XT 12GB | Vega 8 | Sapphire Pulse RX580 8GB
Storage Samsung 980 nvme (Primary) | some samsung SSD
Display(s) Dell 2723DS | Some 14" 1080p 98%sRGB IPS | Dell 2240L
Case Ant Esports Tempered case | Thinkpad | Antec
Audio Device(s) Logitech Z333 | Jabra corpo stuff
Power Supply Corsair RM750e | not needed | Corsair GS 600
Mouse Logitech G400 | nipple
Keyboard Logitech G213 | stock kb is awesome | Logitech K230
VR HMD ;_;
Software Windows 10 Professional x3
Benchmark Scores There are no marks on my bench
Joined
Nov 10, 2008
Messages
1,982 (0.35/day)
Processor Intel Core i9 9900k @ 5.1GHZ all core load (8c 16t)
Motherboard MSI MEG Z390 ACE
Cooling Corsair H100i v2 240mm
Memory 32GB Corsair 3200mhz C16 (2x16GB)
Video Card(s) Powercolor RX 6900 XT Red Devil Ultimate (XTXH) @ 2.6ghz core, 2.1ghz mem
Storage 256GB WD Black NVME drive, 4TB across various SSDs/NVMEs, 4TB HDD
Display(s) Asus 32" PG32QUX (4k 144hz mini-LED backlit IPS with freesync & gsync & 1400 nit HDR)
Case Corsair 760T
Power Supply Corsair HX850i
Mouse Logitech G502 Lightspeed on powerplay mousemat
Keyboard Logitech G910
VR HMD Wireless Vive Pro & Valve knuckles
Software Windows 10 Pro
The demonstration delivered the data throughput projected to be required to run all credit card transactions on the planet

It would probably take all the credit card transactions on the planet to pay for the damned thing :p
 

de.das.dude

Pro Indian Modder
Joined
Jun 13, 2010
Messages
8,756 (1.74/day)
Location
Stuck in a PC. halp.
System Name Monke | Work Thinkpad| Old Monke
Processor Ryzen 5600X | Ryzen 5500U | FX8320
Motherboard ASRock B550 Extreme4 | ? | Asrock 990FX Extreme 4
Cooling 240mm Rad | Not needed | hyper 212 EVO
Memory 2x16GB DDR4 3600 Corsair RGB | 16 GB DDR4 3600 | 16GB DDR3 1600
Video Card(s) Sapphire Pulse RX6700XT 12GB | Vega 8 | Sapphire Pulse RX580 8GB
Storage Samsung 980 nvme (Primary) | some samsung SSD
Display(s) Dell 2723DS | Some 14" 1080p 98%sRGB IPS | Dell 2240L
Case Ant Esports Tempered case | Thinkpad | Antec
Audio Device(s) Logitech Z333 | Jabra corpo stuff
Power Supply Corsair RM750e | not needed | Corsair GS 600
Mouse Logitech G400 | nipple
Keyboard Logitech G213 | stock kb is awesome | Logitech K230
VR HMD ;_;
Software Windows 10 Professional x3
Benchmark Scores There are no marks on my bench
Joined
Oct 30, 2008
Messages
1,757 (0.31/day)
System Name Lailalo
Processor Ryzen 9 5900X Boosts to 4.95Ghz
Motherboard Asus TUF Gaming X570-Plus (WIFI
Cooling Noctua
Memory 32GB DDR4 3200 Corsair Vengeance
Video Card(s) XFX 7900XT 20GB
Storage Samsung 970 Pro Plus 1TB, Crucial 1TB MX500 SSD, Segate 3TB
Display(s) LG Ultrawide 29in @ 2560x1080
Case Coolermaster Storm Sniper
Power Supply XPG 1000W
Mouse G602
Keyboard G510s
Software Windows 10 Pro / Windows 10 Home
It would probably take all the credit card transactions on the planet to pay for the damned thing :p

Nah, that would be if it was Intel based ;)

AMD...just takes a few continents :D
 
Joined
Mar 27, 2008
Messages
697 (0.12/day)
Location
Zagreb, Croatia
Processor C2D E8400@3.9GHz (488x8, 1.4v :( )
Motherboard Abit IP35-E
Cooling Thermaltake Sonic Tower+120mm fan
Memory 2GB kingmax ddr1066@976MHz 5-5-5-15
Video Card(s) Radeon X1800GTO @700/1400MHz with Accelero S1+Glacialtech fancard
Storage 2xSeagate Barracuda 7200.10 160GB
Display(s) Samsung SyncMaster 793s... just you laugh...
Case some Aplus case
Audio Device(s) Realtek ALC888
Power Supply Chieftec 450W
Software Win7 x64
handling gazillions of transactions looks like exactly the workload bulldozer excels in.
 

btarunr

Editor & Senior Moderator
Staff member
Joined
Oct 9, 2007
Messages
46,277 (7.69/day)
Location
Hyderabad, India
System Name RBMK-1000
Processor AMD Ryzen 7 5700G
Motherboard ASUS ROG Strix B450-E Gaming
Cooling DeepCool Gammax L240 V2
Memory 2x 8GB G.Skill Sniper X
Video Card(s) Palit GeForce RTX 2080 SUPER GameRock
Storage Western Digital Black NVMe 512GB
Display(s) BenQ 1440p 60 Hz 27-inch
Case Corsair Carbide 100R
Audio Device(s) ASUS SupremeFX S1220A
Power Supply Cooler Master MWE Gold 650W
Mouse ASUS ROG Strix Impact
Keyboard Gamdias Hermes E2
Software Windows 11 Pro
handling gazillions of transactions looks like exactly the workload bulldozer excels in.

Bingo. That's what AMD processors have been good at in general. Pushing bits around quickly with minimal number crunching. Intel processors with QPI can do that just as well, but they tend to have higher price/throughput ratios than AMD.

But servers that require heavy number crunching (say Flickr's servers that run countless instances of imagemagic (resizing, image manipulation), or YouTube (video transcoding/compression)), Intel all the way.
 

Captain.Abrecan

New Member
Joined
Oct 21, 2010
Messages
175 (0.04/day)
Location
MA
System Name MHI 0000001
Processor Intel Pentium D 950 Presler
Motherboard Asus P5N-32 SLI
Cooling Stock Air
Memory 4x Corsair ValueRAM DDR2 667 1GB
Video Card(s) EVGA 9800 GTX
Storage 4x Seagate Barracuda 500GB 7200RPM
Display(s) HP 17" CRT 1600x1200
Case Thermaltake Armor Black
Audio Device(s) Creative Soundblaster
Power Supply Thermaltake Toughpower 850
Software Microsoft Windows XP Professional
btarunr, I want you to know that I blame you for my intense chocolate craving right now. :cry:
Guess I'm going out for lunch today...
 
Joined
Apr 5, 2005
Messages
6,770 (0.98/day)
Location
Republic of Asia (a.k.a Irvine), CA
System Name ---
Processor FX 8350 @ 4.00 Ghz with 1.28v
Motherboard Gigabyte 990FX-UD3 v4.0, Hacked Bios F4.x
Cooling Silenx 4 pipe Tower cooler + 2 x Cougar 120mm fan, 3 x 120mm, 1 x 200 mm Red LED fan
Memory Kingston HyperX DDR3 1866 16GB + Patriot Memory DDR3 1866 16GB
Video Card(s) Asus R9 290 OC @ GPU - 1050, MEM - 1300
Storage Inland 256GB PCIe NVMe SSD for OS, WDC Black - 2TB + 1TB Storage, Inland 480GB SSD - Games
Display(s) 3 x 1080P LCDs - Acer 25" + Acer 23" + HP 23"
Case AeroCool XPredator X3
Audio Device(s) Built-in Realtek
Power Supply Corsair HX1000 Modular
Software Windows 10 Pro 64 bit
AMD and M$ SQL FTW :rockout:
 

WarraWarra

New Member
Joined
Nov 23, 2010
Messages
268 (0.05/day)
@Captain, you should divert that to cocoa flavored body lotion that your girlfriend / wive uses then you would really get addicted. Not sure if you can get it in USA, they have it in Mexico for dry skin, smells marvelous.

@OP, This is great news, surely there would be better results if you use a properly optimized system / not using MS SQL. Seems like there is a long road ahead to optimize programs for the Interlagos / Magny-Cours.

Wonder what Intel Xeon's would be able to do in a similar config.
 
Joined
Nov 13, 2009
Messages
5,614 (1.07/day)
Location
San Diego, CA
System Name White Boy
Processor Core i7 3770k @4.6 Ghz
Motherboard ASUS P8Z77-I Deluxe
Cooling CORSAIR H100
Memory CORSAIR Vengeance 16GB @ 2177
Video Card(s) EVGA GTX 680 CLASSIEFIED @ 1250 Core
Storage 2 Samsung 830 256 GB (Raid 0) 1 Hitachi 4 TB
Display(s) 1 Dell 30U11 30"
Case BIT FENIX Prodigy
Audio Device(s) none
Power Supply SeaSonic X750 Gold 750W Modular
Software Windows Pro 7 64 bit || Ubuntu 64 Bit
Benchmark Scores 2017 Unigine Heaven :: P37239 3D Mark Vantage
pretty impressive
 
Top