사례 연구

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.

앞으로 플래시를 사용할 준비가 되셨습니까?

포츈지 500대 대기업이든 5명이서 출발하는 신생 기업이든 관계없이, SanDisk는 인프라 활용도를 극대화하는 데 도움이 되는 솔루션을 보유하고 있습니다.

VIA
이메일

질문을 하시면 저희가 답변을 드리겠습니다.

대화해 봅시다
800.578.6007

망설이지 말고, 잠시 얘기를 나누면서 완벽한 플래시 솔루션 구축을 시작하십시오.

판매 문의

몇 가지 간단한 질문을 하려는 경우든, 조직의 요구에 맞게 설정된 SanDisk 솔루션에 대해 논의할 준비가 되어 있든 관계없이, SanDisk 영업 팀이 항상 도움을 드리기 위해 대기하고 있습니다.

아래 양식을 작성해 주시면 질문에 기꺼이 답변해 드릴 것입니다. 영업 팀에 바로 연락해야 한다면 다음 전화 번호를 이용하십시오: 800.578.6007

필드를 비워둘 수 없습니다.
필드를 비워둘 수 없습니다.
올바른 이메일 주소를 입력하십시오.
필드에는 숫자만 사용할 수 있습니다.
필드를 비워둘 수 없습니다.
필드를 비워둘 수 없습니다.
필드를 비워둘 수 없습니다.
필드를 비워둘 수 없습니다.

관심 분야에 표시하십시오:

질문 또는 의견:

옵션을 선택해야 합니다.

감사합니다. 요청을 접수했습니다.