Примеры

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.

ВПЕРЕД С ФЛЕШ-ТЕХНОЛОГИЯМИ!

SanDisk предлагает решения, которые помогут оптимально использовать инфраструктуру как компании из списка Fortune 500, так и стартапа с пятью сотрудниками.

ПО
ЭЛЕКТРОННОЙ ПОЧТЕ

Задавайте вопросы, а мы постараемся ответить на них в кратчайшие сроки.

Мы будем рады вас услышать
800.578.6007

Давайте обсудим, как создать идеальное решение на базе флеш-памяти.

ОБРАЩЕНИЯ ПО ВОПРОСАМ ПРОДАЖ

Персонал отдела продаж SanDisk готов ответить на ваши вопросы и обсудить разработку специализированного решения SanDisk для вашей организации.

Мы будем рады ответить на ваши вопросы, для этого просим вас заполнить форму. Для того чтобы связаться с отделом продаж прямо сейчас, позвоните по телефону: 800.578.6007

Поле не может быть пустым.
Поле не может быть пустым.
Введите правильный адрес электронной почты.
Поле может содержать только числа.
Поле не может быть пустым.
Поле не может быть пустым.
Поле не может быть пустым.
Поле не может быть пустым.

Укажите интересующие вас области:

Вопросы и замечания:

Нужно выбрать один из вариантов.

Спасибо. Мы получили ваш запрос.