Leading European web, mobile and social analytics provider’s innovative Fusion ioMemory™ system improves customer service and its bottom line.
Established in 1995, AT Internet is a leading independent web, mobile and social analytics solution provider in Europe. Its expertise in the field of online intelligence has enabled it to develop unique and innovative solutions, allowing it to measure web traffic, Internet user behaviour, the performance and availability of websites, and management of the company’s online reputation.
AT Internet Technical Architect Thomas Fisher described the growing problem with AT Internet’s database: “For the past three years, we have offered customers real-time statistics (under 1 minute) on website usage. As our customer-base grew, it became harder and harder for our SQL Server database to meet this SLA. Each additional server provided less and less performance. We were up to 12 database servers and needed to find a more affordable and scalable solution.”
Thomas’ team needed a solution that could give AT Internet the following:
The motivating driver behind Thomas’ investigation into the SanDisk solution was to get more performance with less scale-out.
Thomas moved the most active databases onto Fusion ioMemory ioDrive® products while keeping the tempDB on disks and cooler databases on a SATA disk array. He quickly discovered just how well ioMemory met his needs. “Each server with a six-disk array peaked at about 1,400 total disk transfers per second. The Fusion ioMemory-based servers peaked at over 8,000 disk transfers per second and an additional server scaled performance to nearly 14,000 disk transfers per second.”
“Importantly, the Fusion ioMemory-based servers achieved this performance without any noticeable queuing, which insulates us against traffic spikes,” Thomas added. “I estimate the ioDrive performance has reduced database request times by six times.”
The charts below show the average disk queue length and the request times.
Ultimately, the reason why Thomas’ team implemented its innovative solution was to improve AT Internet’s customer service. The SanDisk powered system delivered.
“Our system runs continuous batch jobs on the day’s data—and it now does so much faster. Processes that used to take three seconds now complete in less than a second, which means our customers can always see site activity in real-time,” Thomas said. “When our system was under heavy load, customers real-time reports might take from three to five minutes to complete. We can now deliver these in under a minute, even under the largest traffic spikes.”
Technical Architect, AT Internet
Stopping the Scale-Out
Not only did Thomas’s team improve the performance of its Microsoft SQL Server database by six times, but they also did so with one-sixth the number of servers. The ROI was clear.
Thomas said, “In our previous system, the return on investment for each new server was reaching its limit. Our databases have a write-intensive workload that makes disk performance extremely expensive. We considered purchasing a SAN, but it would have taken more than 100 disks, plus we would have had to install a Fibre Channel system and Fibre Channel cards just to meet our needs. It only took two servers with a single ioDrive in each to give us six times the performance we had before.”
The Cost-Saving Multiplier of Consolidation
The cost savings AT Internet realized were significant, and include the following:
5 x 2U servers, 4 x quad-core 2.66GHz processors, 16GB RAM
9 x blade servers (in 9U Enclosure), 6 x quad core 2.26GHz processors, 16GB RAM
2 x 4U servers, octa-core 2.13GHz processor, 64GB RAM
Implementing ioMemory gave AT Internet the following benefits:
About AT Internet
Established in 1995, AT Internet is a leading independent web, mobile and social analytics solution provider. A leader in Europe in the field of online intelligence, its expertise and technology have enabled the company to develop unique and innovative solutions allowing it to measure web traffic, Internet user behaviour, the performance and availability of websites, as well as to manage a company’s online reputation. AT Internet has approximately 3, 500 clients worldwide, including some of the largest companies and institutions in the world. With its Headquarters in Bordeaux, and thanks to its subsidiaries, AT Internet operates in 9 different countries worldwide including Germany, England, Ireland, Spain and Canada. It currently employs 150 people on an international level, with approximately 60% of its staff working in R&D.
Whether you'd like to ask a few initial questions or are ready to discuss a SanDisk solution tailored to your organizations's needs, the SanDisk sales team is standing by to help.
We're happy to answer your questions, so please fill out the form below so we can get started.
Thank you. We have received your request.