Примеры

Equinox Creates a Fiscally Fit Data Warehouse with Fusion ioMemory™ System

A single Fusion ioMemory ioDrive® card added to the database system of the company voted “Best Gym in America” resolved the data warehousing performance issues.

Solution Focus

  • Microsoft SQL Server
  • Business Intelligence/Data Warehousing

Summary of Benefits

  • 10-20x faster query processing
  • 4-6x faster reporting
  • Inform managers quickly and dependably, so they can perform their best
  • Focus IT resources on higher return projects than performance improvements
  • Cost is less than SAN, while lowering operating costs and adding room for growth
  • In-place improvement of legacy reporting system

The Challenge

Voted Best Gym in America by Fitness Magazine, Equinox Fitness Clubs operates 48 upscale, full-service facilities in New York, Chicago, Los Angeles, Florida, Boston, San Francisco, Dallas, and Washington DC that cater to over 160,000 members.

Equinox’s data warehouse allows managers at all clubs to run reports that help them with everything from monitoring their daily results to managing customer service and revenue opportunities. However, its single Microsoft SQL Server database was struggling to handle the hundreds of daily reports run by hundreds of unique users.

Equinox’s Director of Enterprise Data, Elliott Cordo, told us, “Our data warehouse is critical to our operations. It is used by nearly everyone, from personal training managers, sales managers, and regional managers running reports for daily operations to power users reporting for in-depth analysis and strategy.”

Job running time was growing and often not completing before business hours. When this happened, Equinox’s IT team had to re-run them the following evening, which meant that managers didn’t have the information they needed to run at their best.

As the leader of a team whose company lifestyle brand emphasized innovation, Elliot knew he could devise a solution that would ensure that reports completed on time, without breaking his budget.

"Our data warehouse load, which used to take four to six hours to complete, now completes in under an hour. We can now publish reports much earlier and dependably."

Elliott Cordo,
Director of Enterprise Data, Equinox

The SanDisk® Solution

A Data Warehouse Power-Lifter
Elliott selected the Fusion ioMemoryTM solution for its superior performance and ease of deployment. A single Fusion ioMemory ioDrive® card added to Equinox’s database system resolved the data warehousing performance issues.

Elliott said, “Some of our query loads that used to run at a couple hundred rows per second now run at three to five thousand rows per second, regardless of whether operations are inserts or updates. Database performance is regularly ten to twenty times what it used to be.”

 

Query Load Improvement

With SanDisk
5,000
Without SanDisk
200
18x
Improvement

 

Improving the database performance translated into dramatic improvement on reporting job time. Elliott said, “Our data warehouse load, which used to take four to six hours to complete, now completes in under an hour. We can now publish reports much earlier and dependably.”

 

Reporting Completion Time

With SanDisk
1 hour
Without SanDisk
6 hours
6x
Improvement

 

Lean and Mean Intelligence
Not only did the ioDrive solution offer unmatched I/O performance, it cost less than a disk-based system.

Elliott said, “Getting the I/O we needed from a SAN or NAS solution would take a refrigerator-sized system. A disk-based solution that just met our performance needs would have cost more than the SanDisk solution. The ioDrive cards give us so much more I/O headroom that we won’t need to upgrade for performance for some time.”

Additionally, the SanDisk-powered system had lower operating costs.

Elliott told us, “Our old system had to support a sustained 2,000 IOPS. That takes a lot of conventional drives. Since installing the ioDrive card, I have never seen a significant queue, even under our heaviest loads. The Fusion ioMemory solution does this without the additional complexity of a SAN, which would increase colocation fees and use more power.”

Shaping Up a Legacy Reporting System
In addition to its data warehouse, Equinox maintained a legacy reporting system that was being slowly migrated to the data warehouse. As a short-term fix, Elliott added an ioDrive card to the system. The results were remarkable.

Elliott said, “A lot of reports on the legacy system could not render fast enough to make them functionally useful. We added an ioDrive card and the reports now run so fast that a lot of the users think we migrated them to the new platform ahead of schedule—and we didn’t need to do a thing to the application.”

 

  • Two 2U HP DL380 servers, Dual Quad-Core,2.53 Ghz CPU, 32GB RAM
  • OS: Windows 2008
  • ioDrive Duo 640GB card stores all primary database data
  • ioDrive Duo 1.28TB card stores failover database and some data marts
 

Performance per Rack Unit (Density)

With SanDisk
Without SanDisk
18x
Improvement
Query load improvement 18x in the same rack space.

 

This benefits more than just the business users. As Elliott noted, “Because we can now run legacy reports at high service levels, we can focus on projects with higher business return instead of putting out system slowness fires.”

 

Summary

Implementing the Fusion ioMemory solution gave Equinox the following benefits:

  • 10-20x faster query processing
  • 4-6x faster reporting
  • Inform managers quickly and dependably, so they can perform their best
  • Focus IT resources on higher-return projects than performance improvements
  • Cost is less than SAN, while lowering operating costs and adding room for growth
  • In-place improvement of legacy reporting system

 

Faster reporting made Equinox a more powerful and flexible organization that was always armed with the latest intelligence. Elliott told us, “By ensuring reports always complete overnight, we greatly improve the effectiveness of our operations. Personal training managers can always be on the floor at 9:00am conducting business, knowing the active sales promotions and the members they need to contact. Sales managers can start the day with the latest customer and lead data instead of sitting in their office reviewing yesterday’s results.”

 

About Equinox

Equinox Fitness Clubs operates 48 upscale, full-service facilities in New York, Chicago, Los Angeles, Florida, Boston, San Francisco, Dallas and Washington DC. The company offers an integrated selection of Equinox-branded programs, services and products, including strength and cardio training, group fitness classes, personal training, spa services and products, apparel and food/juice bars. Since its inception in 1991, Equinox has developed a lifestyle brand that represents service, value, quality, expertise, innovation, attention to detail, market leadership and results.

In addition to the 48 Equinox Fitness Club facilities, Equinox has partnered with Pure Yoga, who has studios in Hong Kong, Singapore, and Taipei. Equinox operates two Pure Yoga studios in New York City. Named “Best Yoga” by New York Magazine, Pure Yoga opened its first location in 2008 on the Upper East Side, with the second location on the Upper West Side following in Winter 2009. Pure Yoga offers the best instructors in NYC, teaching over 100 scheduled classes per week across 27 different styles of yoga. It also frequently hosts master classes and workshops, integrating world-renowned guest faculty and unique yoga programs into multiple community events.

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

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

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

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

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

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

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

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

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

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

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

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

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

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