Case Study – NCache Enhances Resource Usage by 30% at VHM

Challenge

Virgin HealthMiles uses ASP.NET Web servers, middle tier application servers, and database servers to support its website. With the increasing amount of traffic coming to its website, the database servers were consistently being hit the hardest, according to Dhinsa. Interestingly while this traffic was creating a tremendous load on the database servers, a great portion of the data being accessed from the database was mostly identical for multiple visitors. Dhinsa explained, "For example, users access data about the challenges they have in progress and company-based information, among other pieces of data. They access this data over and again, and multiple users are accessing the same common data."

"During peak traffic hours, our site gets thousands of visitors per hour. With many users taking part in the same challenges or being part of the same employer group, the database is often running the same query and returning the same data over and over. At the number of users grew, we could see that this could be a potential bottleneck." Consequently, he added, "We wanted to ensure we scaled the platform to accommodate the forecasted growth and we needed a solution that would reduce the resource requirements on the database servers. In a clustered environment, we were fortunate to manage this initially by adding another database server to the cluster. But that wasn't efficient and definitely not financially sustainable. So we started exploring the option of distributed caching technology."

NCache Solution

Virgin HealthMiles found NCache by Alachisoft to be the ideal solution for administering the challenges of rising traffic, as faced by many firms recently. Many company websites face the same scalability bottleneck issues when their ASP.NET applications are managing staggering loads of data requests. Many applications run in load balanced server farms and handle thousands of transactions per second and hundreds of thousands of concurrent users because their overall architecture is very scalable except for one weak link. And, this weak link is the database that is not scalable. As the saying goes, “the strength of any chain is only as strong as its weakest link.” Therefore, data access can easily become a major bottleneck toward scalability.

Dhinsa said, “Member traffic continued growing at a steady clip and we noticed our database servers were being affected the most. That led us to NCache to reduce the load on the database servers without having to keep throwing more database servers at preventing bottlenecks. We now use NCache to temporarily store all the common data that's used over and again. With this, a considerably large number of trips to the database are saved, which eliminates previous database retrieval and prevents traffic buildup bottlenecks.” He added that “Virgin HealthMiles doesn't use ASP.NET Session State object, but we're instead tracking user sessions through our own custom session object.” While they don't use NCache for session storage, per se, they have their custom session object implemented in the application. Part of the custom session object is stored in NCache for a certain amount of time with the cache validity for up to a minute. After which it expires and invalidates itself and then refreshes again from the database.

What to Do Next?

• NCache Details
• Download NCache
• Request a Personalized LIVE Demo