案例研究

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.

Solution Focus

  • Microsoft® SQL Server 2008 R2
  • Spira Command (field ticketing application)
  • Energy

Summary of Benefits

  • 32X faster payroll processing
  • 4 to 1 batch job consolidation
  • Regained up to 52 days of productivity for 10 employees
  • 80% performance headroom for future growth
  • Added a year to the life of its SAN

The Challenge

Savanna Energy Services Corp. (Savanna) is a premiere North America energy services provider headquartered in Calgary, Alberta, whose primary offerings include conventional drilling, hybrid drilling, and well servicing.

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:

  1. Significantly reduce payroll batch processing times.
  2. Enable the system to be used by employees while payroll jobs are running.
  3. 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.”

Jim Clarke, Network Infrastructure Manager Savanna Energy Services Corp.

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.”

System Before

Database Servers

  • 1 x 3U blade server, 2 x dual-core Intel Xeon 3 GHz, 8GB RAM
  • OS: Windows Server 2008 Standard
  • Application: Microsoft SQL Server 2008 R2

Storage

  • 8 x 15K RPM SAS drives on a RAID 5

System After

Database Servers

  • Upgraded server from 2-core blade server to a 6-core rack-mount server
  • Moved all database data from storage onto an ioDrive®320GB card

Summary

Implementing the Fusion ioMemory solution gave Savanna Energy Solutions the following benefits:

  • 32X faster payroll processing
  • 4 to 1 batch job consolidation
  • Regained up to 52 days of productivity for 10 employees
  • 80% performance headroom for future growth
  • Added a year to the life of its SAN
 

About Savanna Energy Services Corp.

Savanna Energy Services Corp. (Savanna) is a premiere North American energy services provider headquartered in Calgary, Alberta.

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.

準備好快閃向前了嗎?

無論貴公司是《財星》雜誌排名前 500 大企業或五人小型創業公司,SanDisk 都有能助您將基礎架構發揮最大功能的解決方案。

透過
電子郵件

請不吝提問,我們會盡快回覆。

與我們談談
800.578.6007

別再猶豫,立即與我們聯繫,開始建立完美的快閃解決方案。

業務洽詢

無論您是想先提出幾個問題,或是已準備好討論符合貴組織需求的 SanDisk 解決方案,SanDisk 銷售團都很樂於隨時提供服務。

請填寫下列表格,我們很榮幸能回答您的疑問,並展開討論。若您需要直接與銷售團隊討論,請來電:800.578.6007

欄位不可為空白。
欄位不可為空白。
請輸入有效的電子郵件地址。
欄位中只能包含數字。
欄位不可為空白。
欄位不可為空白。
欄位不可為空白。
欄位不可為空白。

請指出您有興趣的領域:

提問或意見:

您必須選擇一項。

感謝您。我們已收到您的要求。