First Rate allows investment companies to outsource their business intelligence and to generate high quality reports based on that analysis. They operate in the financial industry, where the phrase “time is money” has very real implications. So when their middleware servers began to bog down, they acted quickly.
First Rate allows investment companies to outsource their business intelligence and generate high-quality reports based on that analysis. They operate in the financial industry, where the phrase “time is money” has very real implications. So when their middleware servers began to bog down, they acted quickly.
After-hour processing was taking far too long, extending into the morning hours. As clients began using the application, system performance worsened. As a provider of top-tier business intelligence, First Rate found this performance unacceptable to themselves and to their clients.
Steve Schneider, First Rate’s network administrator, analyzed their system and found that their reporting server’s primary problem was poor I/O. Evidence of this included a high disk queue, showing the processor was waiting on the hard disk, and a dismal processor utilization of 50%. Additionally, the system suffered from major disk thrashing in the morning, when the after-hours processing and the reporting application began competing for I/O, forcing the system to switch between operations.
Recognizing that they had to somehow improve processor utilization, Steve implemented a short-term but inadequate stopgap of a 1TB PE220s vault as he looked for a long-term solution. While a SAN might provide the necessary performance, such a solution was cost prohibitive. Alternate solutions that fit into their budget (such as software based RAM Disks utilizing the on-board RAM DIMMs) were unstable. After reading an article about SanDisk® Fusion ioMemoryTM solutions on an online hardware site, he was stunned at the performance gains other companies were experiencing and decided to give some Fusion ioMemory ioDrive® cards a try.
Network Administrator, First Rate
The SanDisk® Solution
First Rate’s middleware environment consisted of four front-end Information Builder WebFocus reporting servers and two Microsoft SQL database servers. The core investment analysis was performed on the front-end servers by the WebFocus application, so Steve decided to focus his efforts on improving the front-end server performance.
Knowing that the SanDisk solution was designed to improve application I/O, Steve decided to test moving the files that experienced the highest I/O onto ioDrive cards. These files were WebFocus’s Edatemp files.
First Rate ran benchmark tests with the Edatemp files located on three different storage media:
Each test ran forty WebFocus agents against 46,000 accounts (all accounts flagged daily) on two months worth of data and generated 139 million Unit Value Returns (UVRs).
Just one ioDrive card on each reporting server (for a total of four) improved processor utilization four-fold, allowing First Rate to do three times the work in the same amount of time. It also allowed Steve to repurpose the vaults for more standard storage uses. The results of the test are shown below.
|Edatemp On||CPU Utilization||Time for Completion|
|PE220s Vault||50%||4:22 hours|
|2-drive SAS RAID||50%||4:30 hours|
|80GB ioDrive cards||90–100%||1:30 hours|
The ioDrive cards’ performance allowed First Rate’s after-hours processing to complete on time, their application to perform at top speeds, and most importantly, it allowed their clients to manage their investments without slowdown.
Steve had the following to say about the results, “We are thrilled with the way ioDrive cards allow us to offer our clients unparalleled performance. We expect a full return on our investment within six months.” He is now planning to test Fusion ioMemory products on First Rate’s databases.
Four reporting servers (1U each)
The Fusion ioMemory solution delivered the following benefits to First Rate.
About First Rate
First Rate® provides investment performance measurement and analysis solutions to the wealth management industry. The First Rate Performance Solution allows investment firms to calculate accurate rates of return, better analyze the results efficiently and generate dynamic “boardroom quality” presentations for their clients. As a trusted advisor, First Rate provides its customers with a level of focus, depth and expertise that is truly unique to the industry.
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.