案例研究

SanDisk and Savanna Energy Services Flying High in Canada

Savanna Energy Services Corp. is a premiere energy services provider headquartered in Calgary, Alberta, whose primary offerings include conventional drilling, hybrid drilling, and well servicing. By deploying High IOPS Adapters, the company was able to process payroll jobs 32 times faster and regain more than 50 days of productivity annually for 10 employees.

Savanna Network Infrastructure Manager, Jim Clarke, described a major difficulty Savanna had in running weekly payroll for approximately 457 field employees: “The main reason we were struggling was that when we would run payroll jobs, they took approximately 8 –10 hours to complete. When that process was being run, our SQL Server 2008 database with local disk was completely maxed out from an I/O perspective, and could not be used for other tasks; the server was completely inaccessible—no one else could go on the system and do anything.”

Jim’s team was looking for a solution that could accomplish the following:

Significantly reduce payroll batch processing times.

Enable the system to be used by employees while payroll jobs are running.

Scale to future growth.

In Jim’s words, his team was “grasping at straws” to find a solution to the I/O bottleneck. Enter SanDisk’s Fusion ioMemoryTM solutions.

The Solution

As Jim investigated solutions, his infrastructure team came across Fusion ioMemory products. They quickly initiated a proof-of-concept.

Propelling Payroll Job Processing
pPrior to implementing the Fusion ioMemory solution, Savanna’s entire payroll batch exceeded Spira’s three-hour time-out window. Consequently, they had to break up payroll into four separate batch jobs, each of which took around two hours.

Savanna’s existing system consisted of a Microsoft® SQL Server database with local disks backed by a SAN. Jim’s team moved the production server’s database onto a Fusion ioMemory ioDrive® card in a test database server. On the very first test, a payroll batch that typically took two hours to ran completed in just 10 minutes, including SQL indexing.

Jim said, “We thought something was wrong; there’s no way it is done. That’s not even possible.” But it proved to be true.

Single Payroll Batch Time

With SanDisk

10 minutes

Without SanDisk

2 hours

12x

Improvement

Freeing the System from Batch Process Blockage
After seeing the speed that the ioDrive card delivered, Jim decided to attempt running the entire payroll process in one batch. The SanDisk-powered system came through in this scenario as well: the entire job time was reduced from 8 hours to 15 minutes, well below the time-out window.

Full Payroll Processing Time

With SanDisk

15 minutes

Without SanDisk

8 hours

32x

Improvement

Jim commented, “The benefits have been incredible. We are now fully utilizing the CPU, while the ioDrive cards aren’t even breaking a sweat. We have successfully pushed the resource bottlenecks to the CPU and RAM on the servers, while the ioDrive cards can support 80-85% more workload.”

“Prior to implementing SanDisk, we had to break up the payroll job into four separate batches to prevent the application from timing out. The entire job took 8–10 hours. With the new system, we can run payroll as a single batch in 15 minutes.”

Delivering Human Resources from I/O Tyranny
Previously the payroll process stalled work for 10 payroll employees all day, every Wednesday—and may have indirectly affected the work of many more employees. The SanDisk-powered system not only shrank the payroll-processing window to just 15 minutes, it eliminated the resource contention that prevented these employees from working with the system during this time.

Jim said, “Before, maybe 10 employees couldn’t work in our field ticketing application, Spira. Now, the entire payroll job takes around 15 minutes and employees can continue using the system even while the job is running. It also frees our IT staff from checking for application time-outs and restarting stalled jobs— something that was part of the routine before.”

A Single Solution for Payroll and SAN Scalability
The benefits of investing in the Fusion ioMemory solution extended beyond freeing system and personnel resources; it also increased Savanna’s return on investment and ensured that savings will continue even as the company grows.

Jim said, “Even under the servers’ maximum workload, we are using just 20% of the ioDrive card’s performance capacity, which gives us good room to grow.”

Jim also noted how moving the database to Fusion ioMemory cards freed its storage system for other processes, deferring the need for an upgrade: “The SAN is a very reliable piece of hardware and has been great. Because we aren’t using it for high-transaction processing, we can now use it for many other processes. The SanDisk implementation gave us another year with this system by better balancing its workload.”

Savanna’s primary offerings include conventional drilling, hybrid drilling, well servicing, and comprehensive oilfield services such as oilfield equipment rental, which meet the needs of their diverse oil and gas customer base. Savanna is uniquely positioned in the energy services industry, incorporating Aboriginal partnerships and community involvement with leading technology that includes PLC-controlled service rigs and patented hybrid drilling rigs.

Footnotes

The performance results discussed herein are based on internal Savanna testing and use of Fusion ioMemory products. Results and performance may vary according to configurations and systems, including drive capacity, system architecture and applications.