Casi di studio

From Hours to Seconds: QuestPoint Accelerates Time to Business Intelligence with Fusion ioMemory Solutions

Moved mission-critical OLTP and OLAP databases off the SAN and onto Fusion ioDrive products in the database servers. This eliminated I/O delays in the transactional databases and accelerated reporting times in its data warehouse.

Solution Focus

  • Web Analytics
  • Microsoft SQL Server

The SanDisk® Solution

Moved mission-critical OLTP and OLAP databases off the SAN and onto Fusion ioMemoryTM ioDrive® products in the database servers. This eliminated I/O delays in the transactional databases and accelerated reporting times in its data warehouse.

4x faster transactions per second
Report times reduced from hours to seconds
Supports 10x more user panels and processes more data with the same footprint
Fully utilizes performance potential of differentiated BI application
24-36x faster failover times

“The ioDrive products have a direct bottom-line impact on our business. They allow us to collect and process greater amounts of data faster, which means less wait time for the user and happy customers.”
“OLTP database performance increased from about 20,000 transactions/second (TPS) to over 80,000 TPS.”
“We went from having a user panel of millions to a user panel of tens of millions, while improving the overall experience for our customers.”

Reuben Shaffer,
Chief Information Officer, QuestPoint

The Bottom Line

With the SanDisk solution, QuestPoint was able to speed data collection and processing to improve business intelligence, getting customers faster results than competing services.

  • Enhance value of BI services by giving customers faster, more actionable intelligence
  • Performance headroom to defer SAN performance upgrade indefinitely
  • Maintain same physical footprint to keep hardware, maintenance, and power and cooling costs in check
  • Improve HA by speeding failover times

Transactions per Second (TPS)

With SanDisk
Over 80,000 TPS
Without SanDisk
4x
Improvement

“Business Intelligence (BI) queries that involve billions of records that used to take hours to run now take seconds.”
Reuben Shaffer, Chief Information Officer, QuestPoint

Report Times

With SanDisk
Seconds
Without SanDisk
Hours
100x
Faster

“The average failover time with database mirroring has been about five seconds, whereas the failover time on the SAN was two to three minutes.”
Reuben Shaffer, Chief Information Officer, QuestPoint

Failover Time

With SanDisk
5 seconds
Without SanDisk
up to 180 seconds
24-36x
Faster

System Before

OLTP Database Servers

  • 10 x 2U servers, Intel E7-8837 Quad Socket processor @2.67Ghz, 96GB RAM
  • OS: Windows 2008 R2
  • Applications: Microsoft SQL Server 2008 R2
  • Hard disks: 8 x 15K RPM SAS drives, 600GB per server

Data Warehouse System

  • 1 x 4U server, Intel E7-8837 Quad Socket processor @2.67Ghz, 1TB RAM

System After

Storage

  • iSCSI SAN
  • Moved active data from SAN to one ioDrive Duo 1.28TB device in OLTP Servers
  • Moved active data from SAN to seven ioDrive Duo 1.28TB devices in OLAP server
  • Use SAN for backup/archive only

About QuestPoint

QuestPoint is a global digital marketing and intelligence company. Since 2008, QuestPoint’s been developing the world’s largest panel of online consumer behavior data. Its team of genius data scientists, brilliant marketers, and amazing engineers takes the data that is important to you, simplifies it, and provides you with the information you need to make the best marketing and business decisions possible.

It also uses this data to provide marketing services that generate high quality traffic, leads and customers for online marketers.

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.

VIA
E-MAIL

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

Parliamo!
800.578.6007

Non esitate! Richiedete subito una consulenza per iniziare a creare la soluzione flash perfetta per le vostre esigenze.

Recapiti globali

Come contattare i nostri uffici in tutto il mondo.

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. Se avete bisogno di parlare subito con un addetto alle vendite, chiamate il numero: 800.578.6007

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

Indicare le aree di interesse:

Domande o commenti:

Scegliere un’opzione.

Grazie. Abbiamo ricevuto la vostra richiesta.