Études de cas

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.

PRÊT(E) À AVANCER AVEC LE FLASH ?

Que vous soyez une société Fortune 500 ou une start-up de cinq personnes, SanDisk propose des solutions qui vous aideront à tirer le maximum de votre infrastructure.

VIA
E-MAIL

Allez-y, posez-nous quelques questions et nous vous répondrons.

Parlons-en
800.578.6007

N'attendez-pas, parlons maintenant et commençons à créer la solution flash parfaite.

Contact mondial

Trouvez les coordonnées de nos bureaux partout dans le monde.

DEMANDES DE RENSEIGNEMENT CONCERNANT LES VENTES

Que vous souhaitiez poser quelques questions initiales ou que vous soyez prêt(e) à discuter d'une solution SanDisk adaptée aux besoins de votre société, l'équipe des ventes de SanDisk est présente pour vous aider.

Nous sommes heureux de répondre à vos questions, veuillez donc remplir le formulaire ci-dessous afin de commencer. Si vous avez besoin de parler immédiatement à l'équipe des ventes, veuillez appeler le : 800.578.6007

Le champ ne peut pas être vide.
Le champ ne peut pas être vide.
Veuillez saisir une adresse e-mail valide
Le champ ne peut contenir que des chiffres.
Le champ ne peut pas être vide.
Le champ ne peut pas être vide.
Le champ ne peut pas être vide.
Le champ ne peut pas être vide.
Le champ ne peut pas être vide.
Le champ ne peut pas être vide.

Veuillez indiquer vos domaines d'intérêt :

Vous devez choisir une option.

Questions ou commentaires :

Vous devez choisir une option.

Merci. Nous avons reçu votre demande.