案例研究

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 大企業或五人小型創業公司,SanDisk 都有能助您將基礎架構發揮最大功能的解決方案。

透過
電子郵件

請不吝提問,我們會盡快回覆。

與我們談談
800.578.6007

別再猶豫,立即與我們聯繫,開始建立完美的快閃解決方案。

業務洽詢

無論您是想先提出幾個問題,或是已準備好討論符合貴組織需求的 SanDisk 解決方案,SanDisk 銷售團都很樂於隨時提供服務。

請填寫下列表格,我們很榮幸能回答您的疑問,並展開討論。若您需要直接與銷售團隊討論,請來電:800.578.6007

欄位不可為空白。
欄位不可為空白。
請輸入有效的電子郵件地址。
欄位中只能包含數字。
欄位不可為空白。
欄位不可為空白。
欄位不可為空白。
欄位不可為空白。

請指出您有興趣的領域:

提問或意見:

您必須選擇一項。

感謝您。我們已收到您的要求。