• Per le persone
    • Memoria per dispositivi mobili
      • iXpand™ Memory Case
      • Unità USB Ultra Dual di Tipo C | SanDisk
      • Unità flash iXpand per iPhone e iPad | SanDisk
        • Unità flash iXpand
      • Unità Ultra Dual USB 3.0 | SanDisk
      • Connect Wireless Stick | SanDisk
      • Unità flash Ultra USB Tipo C | SanDisk
      • Unità SanDisk Ultra Dual m3.0 | SanDisk
      • iXpand Base per iPhone | SanDisk
      • Sandisk Dual Drive | SanDisk
    • Schede e lettori
      • SD Cards
        • microSD ExtremePro
        • Scheda di memoria SanDisk Extreme PRO SDHC/SDXC UHS-I
        • Scheda di memoria Extreme PLUS SDHC/SDXC UHS-I | SanDisk
        • Scheda di memoria SanDisk Extreme SDHC/SDXC UHS-I
        • Scheda di memoria Ultra PLUS SDHC/SDXC | SanDisk
        • Scheda di memoria Ultra SDHC/SDXC velocità di lettura 80 MB/s | SanDisk
        • Scheda di memoria SDHC/SDXC | SanDisk
      • Schede microSD | SanDisk
        • Scheda microSD Extreme PLUS UHS-I A1 | SanDisk
        • SCHEDE EXTREME microSDXC e microSDHC UHS-I | SanDisk
        • Scheda microSD Extreme  | SanDisk
        • SanDisk Exteme microSD per action camera | SanDisk
        • Ultra PLUS microSDXC | SanDisk
        • Velocità di lettura 95 MB/s Ultra microSD | SanDisk
        • Scheda Ultra microSD UHS-I per videocamere | SanDisk
        • SanDisk microSD
        • Scheda High Endurance Video Monitoring microSD | SanDisk
        • Scheda Ultra microSD UHS-I velocità di lettura 48 MB/s | SanDisk
        • Ultra microSD per smartphone | SanDisk
        • Scheda Ultra PLUS microSD UHS-I per videocamere | SanDisk
        • Scheda Extreme PRO microSDXC UHS-II | SanDisk
        • microSDXC Ultra PLUS | SanDisk
        • microSDXC Ultra | SanDisk
        • Schede microSDXC SanDisk per Nintendo Switch
        • MicroSDXC Extreme | SanDisk
      • Compact Flash Cards
        • Scheda di memoria SanDisk Extreme Pro CompactFlash
        • Scheda di memoria SanDisk Extreme CompactFlash
        • Scheda di memoria SanDisk Ultra CompactFlash
      • CFast 2.0 Cards
        • Scheda di memoria Extreme PRO CFast 2D | SanDisk
      • Lettori di schede di memoria
        • Reader/Writer Extreme PRO CFast 2.0 | SanDisk
        • Lettore USB 3.0 multifunzione ImageMate | SanDisk
        • Adattatore e lettore MobileMate Duo | SanDisk
        • Lettore USB MobileMate | SanDisk
        • Reader/writer di schede Extreme PRO SD UHS-II | SanDisk
        • Reader/writer di schede Extreme PRO SD UHS-II con USB-C | SanDisk
        • Lettore ImageMate Pro USB 3.0 | SanDisk
    • Flash USB
      • Unità flash SanDisk Extreme Go USB 3.1
      • Unità flash a stato solido SanDisk Extreme PRO USB 3.1
      • Unità flash USB Cruzer Dial
      • Unità flash SanDisk Ultra Flair USB 3.0
      • Unità flash USB 3.0 SanDisk Ultra
      • Unità flash SanDisk Ultra Fit USB 3.0
      • Unità flash USB Cruzer Force | SanDisk
      • Unità flash USB Cruzer Glide
      • Unità flash USB Cruzer Orbit
      • Unità flash USB Cruzer Switch
      • Unità flash USB Cruzer U
      • Unità flash USB Cruzer Blade
      • Unità flash USB Cruzer Edge
      • Unità flash USB Cruzer Fit
      • Unità flash SanDisk Ultra Fit USB 3.1
    • SSD
      • SSD Portatile SanDisk Extreme 900
      • SSD Portatile SanDisk Extreme 510
      • SSD portatile SanDisk Extreme 500
      • SSD SanDisk Ultra II mSATA
      • SSD SanDisk Extreme Pro
      • SSD SanDisk Ultra II
      • SanDisk SSD Plus
      • Kit di strumenti SanDisk SSD Notebook Upgrade
      • SSD SanDisk Ultra 3D
      • Reindirizzamento SSD Ultra 3D
      • SSD Portatile SanDisk Extreme
      • SSD SanDisk Extreme PRO M.2 NVMe 3D
    • Lettori MP3
      • SanDisk Clip Sport
      • Lettore MP3 SanDisk Clip Jam™
      • SanDisk Clip Sport Plus
    • Extreme Team
      • Steve McCurry
      • Akito Mizutani
      • Walter Iooss
      • Elizabeth Kreutz
      • Tom Bol
      • Lucas Gilman
      • Marcelo Maragni
      • Jeff Lewis
      • Corey Rich
      • Christian Pondella
      • Caio Guatelli
      • Terrell Lloyd
      • Michael Grecco
      • Akash Das
      • Kaustav Saikia
      • Mahryska e Tinayums
      • Amy Tierney
      • Alex Liu
      • Scott A. Woodward
      • Steve Simon
      • Kike Calvo
      • C.S. Ling
      • Peter Eastway
      • Cliff Mautner
      • Bambi Cantrell
      • Bob e Dawn Davis
      • Zach e Jody Gray
      • Marcus Bell
      • Sam Nicholson
      • Richard Finn Gregory
      • Vincent Laforet
      • Sebastien Devaud
      • Paolo Baccolo
      • Phil Coates
      • David Newton
      • Daniel Fox
      • FRED POMPERMAYER
      • Christian Nørgaard
      • Kirill Umrikhin
      • Matthew-Jordan-Smith
      • Richard Walch
      • Marcel Laemmerhirt
      • Dom Daher
      • Joao Carlos
      • Claudia Goetzelmann
      • Patrick Bellair
      • Wendell Phillips
      • Tyler Stableford
      • Jonathan e Angela Scott
      • Ellen Anon
      • Daisy Gilardini
      • Georg Tappeiner
      • George Karbus
      • Renan Ozturk
      • Lars Schwellnus
      • Tim Laman
      • Sean Scott
      • Nick Didlick
      • Dave Black
    • Stories
    • Dove acquistare
  • Per le aziende
    • Data center
      • Prodotti
        • Dispositivi flash (non è una pagina)
          • PCIe Flash (non è una pagina)
          • SSD (non è una pagina)
        • Software flash (non è una pagina)
          • Open Source
          • Software ioVDI
      • Soluzioni
        • Database
        • Virtualizzazione
        • Big Data
        • Soluzioni cloud
      • Partner
      • Biblioteca risorse
        • Case Studies
        • Data Sheets
        • Overviews
        • Report
        • Articles
        • Video
        • Solution Briefs
          • All-Flash Storage System for Ceph and OpenStack
          • Red Hat Ceph Storage on the InfiniFlash All-flash Storage Platform
          • The Solution for Cassandra at Scale | SanDisk
          • Storage for MongoDB Analytics
          • Optimizing Ceph Deployments Solution Brief
    • Computing
      • X600
      • X400
      • Z400
      • sn720
      • sn520
    • Foto e video professionali
  • Progettazione per i produttori di apparecchiature originali (OEM)
    • Data center
    • Computing
    • Cellulare
      • Unità flash integrate iNAND
    • Commercial
    • Soluzioni Industrial OEM
      • iNAND
      • Schede industriali
      • Schede OEM
    • Automotive
      • Schede SD per il settore automotive
      • iNAND per il settore automotive
      • Schede SD per il settore automotive
    • Connected Home
    • Blog
  • Informazioni su SanDisk
    • Marchi fidati
      • Storia di innovazioni
      • Il vantaggio di SanDisk
        • Imprese
        • Consumatori
      • In cosa si differenzia SanDisk
      • Iniziative imprenditoriali
    • Centro stampa
      • Comunicati stampa
        • 2017
          • SanDisk® Launches its Fastest, High-Capacity USB Flash Drive Ever
          • SanDisk® Unveils World’s First microSD Card Designed to Deliver a New Dimension of Mobile Application Performance
          • Western Digital Transforms the Mobile Experience with New ‘Smart’ iNAND 7350 Storage Solution Built on 3D NAND
          • SanDisk® Teams with Leading Manufacturers to Offer Consumers a Faster Mobile App Experience
          • SanDisk Now Offers 256GB of Extra Storage for iPhone and iPad
          • Western Digital Introduces iNand 7250a Embedded Storage Device For Evolving Data Demands Of Connected Automotive Technologies
          • Western Digital To Deliver World’s First Client Solid State Drives With 64-layer 3d Nand Technology
      • Awards & Accolades
      • Events
        • Microsoft World Partner Conference
        • International Super Computing
        • Flash Memory Summit
        • Intel Developer Forum 2015
        • VMworld US
        • LinuxCon North America
        • SpiceWorld
        • VMworld Europe
        • VMworld Europe
        • GTEC
        • Microsoft PASS Summit
        • Oracle OpenWorld
        • HP Discover London
        • Gartner Data Center Conference
        • Photo Plus Expo 2015
        • Big Data Expo
        • SQL PASS Summit 2015
        • TigerDirect Innovation – IT Conference and Expo
        • Mobile World Conference
        • Embedded World
        • Open Compute
        • Linux Open Vault Conference
        • LinuxCon North America 2016
        • Western Digital: The Future of Data
      • Risorse multimediali
        • Prodotto
        • Responsabilità sociale
          • Dirigenza
    • Opportunità di impiego
      • Perché SanDisk
        • Compensi e benefit
      • Opportunità per neolaureati
      • Sviluppo della carriera
    • Cittadinanza globale
      • Sociale
      • Ambientale
      • Comunità
      • Studenti
        • Vincitori delle borse di studio
      • Gestione dei fornitori
    • Rapporti con gli investitori
    • Per contattarci
  • Supporto
  • Per le persone
  • Per le aziende
  • Progettazione per i produttori di apparecchiature originali (OEM)
  • Informazioni su SanDisk
  • Supporto
 
  • Data center
    • Computing
    • Foto e video professionali
  • Prodotti
  • Soluzioni
  • Partner
  • Biblioteca risorse

Casi di studio

TekSouth Fights US Air Force Datacenter Sprawl with Fusion ioMemory Solutions

Innovative systems integrator improves USAF financial data warehouse performance, while shrinking footprint 16 to 1 with Fusion ioMemory PCIe drives.

Solution Focus

  • Federal Government
  • Financial
  • Data Warehousing

Summary of Benefits

  • 3X more concurrent users
  • 3X more queries
  • 2X greater workload
  • 16:1 footprint consolidation
  • 1/16th power and cooling
  • Eliminated maintenance overhead for 27 disk arrays and over 400 disks

The Challenge

TekSouth is a privately owned systems integration and professional services company headquartered in Birmingham, Alabama that services both commercial and government sectors. The US Air Force’s (USAF) Commanders’ Resource Integration System (CRIS) is its Authoritative Data Source (ADS) for financial management of unclassified appropriated historical data, and uses TekSouth’s end-to-end decision support architecture. CRIS integrates data from geographically dispersed financial managers and gives them the tools to manage day-to-day operations, while providing senior leaders at all levels a near real-time snapshot of how operational entities are performing.

Mike Rhodes, TekSouth’s VP of Operations, described the challenge CRIS faced: “We’ve been the technical prime for the USAF Financial since 1998. Every five years we do a technical refresh of hardware to improve performance. In the process of the latest rotation we wanted to reduce power, cooling, and overall footprint cost.”

The challenges CRIS faced were daunting:

  1. Deliver near real-time reporting for more than 15,000 users running up to 1.2 million queries per month.
  2. Perform Extract, Transform, and Load (ETL) jobs to prepare data for end users without affecting end-user application performance.
  3. Address increasing pressure for datacenter space and energy conservation.
  4. Meet the USAF’s failover requirements to be operational to users and managers in every time zone around the world.
 

The Solution

After investigating several technologies, TekSouth determined that a system using Fusion ioMemory was the best solution.

Scalable Performance for Ad-Hoc Reporting

The USAF financial warehouse posed significant challenges to scalable performance:

  • Size. The warehouse contains over twenty-two terabytes of data and continues to grow, receiving 250 data feeds daily from 19 systems worldwide.
  • Security overhead. Strict access controls protecting sensitive financial information added to the typical workload of standard data warehouses.
  • Ad-hoc usage patterns. While most data warehouses primarily use canned queries and stored procedures, the vast majority of queries on CRIS are ad-hoc, yet require near real-time responses.

Mike states “CRIS supports multiple-terabyte table processing that reaches up to billions of rows deep. Typical user patterns are nearly 98% ad-hoc, which means we can’t optimize for canned reports.”

“After adding the ioDrive cards, we reduced the system footprint to just three servers that took up about 6 rack units of space.”

Mike Rhodes,
VP of Operations, TekSouth

He then explains how moving the warehouse data onto Fusion ioMemory solutions addresses the problem, “We’ve designed the software CRIS uses to deliver the performance and high uptime the DoD needs. But we were limited by the capabilities of traditional hardware. With disk I/O being the biggest bottleneck, Teksouth’s architecture is built to scale out and isolate I/O intensive processes from one another. Fusion ioMemory eliminates the I/O contention that is the biggest constraint.”

The results were better than he hoped. “We tested the system against real-world historical query workloads rather than synthetic benchmarks, which allowed us to see how the ioDrive cards would perform in actual deployment. A single server with ioDrive cards doubled the workload capability of a 3-server, 21-disk array-based system. At 15 times the standard production workload, we were still operating within the USAF performance requirements,” Mike said.

Mike notes what this performance means to the USAF: “The new system supports three times the number of concurrent users and can run three times the number of queries in the same time. 82% of ad-hoc queries returned in under 10 seconds, while the average response time for all queries, in total, was less than 23 seconds.”

Concurrent Users

With SanDisk
Without SanDisk
3x
Improvement

Query Time

With SanDisk
Without SanDisk
3x
Improvement

Escalating ETL and Availability

In addition to responding to end-users’ ad-hoc queries in near real-time, CRIS runs ETL jobs to prepare data for user consumption. These jobs run as often as hourly, and cannot slow system responsiveness, which would interfere with end users’ productivity.

A disk-based system would require massive overprovisioning to avoid resource contention and system slowness. The Fusion ioMemory system’s low-latency transactional performance enabled a single server to handle both active queries and ETL loads. “We run ETL jobs on a separate server, but this server is a failover for the data warehouse. The USAF requires the warehouse support double its standard query workload, which means that the failover system needs to support both the ETL workload and double the standard query workload.” Mike states “The ioDrive system didn’t begin to see any degradation in ETL job run times until we reached 16 times our normal production workloads.”

 

Shrinking Footprint and Energy Costs

Not only does Fusion ioMemory system double the workload capabilities of the CRIS system, it does so on far less hardware. Mike describes how Fusion ioMemory eliminates the need for massive overprovisioning of disks: “There is a big energy awareness initiative in the US Air Force, as with other areas of the DoD. Before the refresh, this area of CRIS consisted of 5 servers and 27 arrays of disks—about a rack and a half of hardware. After adding the ioDrive cards, we reduced the system footprint to just three servers that took up about 1/16 of the space.”

 

Global Uptime for a Force that Never Sleeps

One might think that the three Fusion ioMemory-based servers would be fully utilized. But in fact, a single server met the USAF’s performance needs. The two additional servers delivered load balancing and redundancy that CRIS required—and without the significant maintenance overhead of the previous, disk-based system.

Mike explains “CRIS is a distributed, scale-out system with 99.97% uptime attributable to its modular architecture that allows redundant subsystems. The ioDrive cards make each piece of hardware much more powerful so it can scale farther. A single server with a Fusion ioMemory ioDrive card handles the workload as well as or better than the three servers and 21 disk arrays we used for handling active queries. CRIS uses all three servers in a distributed architecture to handle and load balance active queries, while using two of these servers in an active-passive configuration to run the ETL jobs offline.”

System Before

Database Servers (20RU)

  • 5 x 4U servers, four quad-core AMD OpteronTM 822 SE processors @ 3.0GHz, 32GB RAM
  • OS: Windows Server 2008 R2 Enterprise Edition
  • Database: Microsoft SQL Server 2008 R2 TDS Edition
  • Hard disks: 5 x 15K RPM SAS drives, 146GB

Storage (81RU)

  • 27 x 3U disk arrays
  • Hard disks: 15 x 15K RPM SAS drives

System After

Database Servers (6RU)

  • 3 x 2U database servers, four hex-core Intel Xeon E5-4610 processors @ 2.40GHz, 64GB RAM

Storage

  • Data stored on one Fusion ioMemoryTM- ioDrive®2 Duo 2.4TB card and one Fusion ioMemoryTM-ioDrive®2 1.2TB card in each server

Summary

Implementing Fusion ioMemory gave TekSouth and the US Air Force the following benefits:

  • 3X more concurrent users
  • 3X more queries
  • 2X greater workload
  • 16:1 footprint consolidation
  • 1/16th power and cooling
  • Eliminated maintenance overhead for 27 disk arrays and over 400 disks
 

About TekSouth

TekSouth Corporation is a thirty year old, privately held firm with headquarters in Birmingham, Alabama, and strategically located program offices in the US and around the world.

Its primary services include the following:

  • Performance Management, Business Intelligence and Decision Support,
  • Custom Application Development, and
  • IT Professional Services

TekSouth has the technical staff and management to perform large enterprise projects but remains customer-centric and able to respond rapidly to changes in requirements and technologies.

TekSouth Fights US Air Force Datacenter Sprawl with Fusion ioMemory Solutions
Download

PRONTI A MIGLIORARE CON LA TECNOLOGIA FLASH?

Che siate una società Fortune 500 o una startup di cinque persone, SanDisk ha soluzioni che vi aiuteranno a sfruttare al meglio la vostra infrastruttura.

RICHIESTA
ONLINE

Inviateci le vostre domande. Saremo lieti di fornirvi le relative risposte.

VENDITE GLOBALI
CONTATTI

Come contattare i nostri uffici in tutto il mondo.

SERVIZIO
CLIENTI

Hai una domanda su un prodotto che hai già acquistato? Possiamo aiutarti!

DOMANDE SULLE VENDITE

Sia che desideriate porre alcune domande iniziali o siate pronti a discutere una soluzione SanDisk su misura per le esigenze della vostra azienda, gli addetti alle vendite SanDisk sono pronti ad assistervi.

Ci impegniamo a rispondervi tempestivamente, compilate il seguente modulo.

Immettere un indirizzo e-mail valido.
Il campo non può essere vuoto.

Indicare le aree di interesse:

Scegliere un’opzione.

Domande o commenti:

Informativa sulla privacy

Grazie. Abbiamo ricevuto la vostra richiesta.

Menu del sito

  • Per le persone
    • Memoria per dispositivi mobili
    • Schede & lettori
    • USB
    • SSD
    • Lettori MP3
  • Per le aziende
    • Data center
    • Computing
    • Partner
    • Foto & video professionali
  • Progettazione per i produttori di apparecchiature originali (OEM)
    • Cellulare
    • Computing
    • Automotive
    • Connected Home
    • Industriali & altri
    • Data center
  • Centro stampa
    • Comunicati stampa
    • Riconoscimenti
    • Risorse multimediali
  • Opportunità di impiego
  • Rapporti con gli investitori
  • Per contattarci

Supporto

  • Supporto alle aziende
  • Supporto per le vendite al dettaglio

Collegamenti rapidi

  • Blog IT
  • Portale del partner di canale
  • I momenti SanDisk
  • Extreme Team

Blog IT

Post Thumbnail

{{feed.title}} | {{getFormattedDate(feed.publishedDate) | date:''}}

Leggi altro »
  • Informazioni legali
  • Condizioni d'uso
  • Marchi commerciali
  • Privacy
  • Cookie
  • Taiwan BSMI RoHS
  • Informazioni sugli annunci pubblicitari
  •  
SanDisk
© 2018 Western Digital Corporation o sue consociate. Tutti i diritti riservati.