• 家用
    • 移动存储
      • 至尊高速 Type-C USB 3.1双接口 OTG 闪存盘 | 闪迪
      • 适用于 iPhone 和 iPad 的欢欣i享™ 闪存盘 | 闪迪
        • 闪迪欢欣i享闪存盘
      • 闪迪至尊高速 OTG USB 3.0 闪存盘 | 闪迪
      • 欢欣畅享™无线闪存盘 | 闪迪
      • 闪迪至尊高速 Type-C 薄型USB闪存盘 | 闪迪
      • 欢欣i享迷你
      • 闪迪至尊高速™酷捷 OTG USB 3.0闪存盘 | 闪迪
      • iPhone专用的闪迪欣享自动备份充电座 | 闪迪
      • 闪迪双接口闪存盘 | 闪迪
      • 至尊™ C 型 USB 闪存盘 | 闪迪
    • 存储卡和读卡器
      • SD Cards
        • 闪迪至尊超极速移动™microSD
        • 闪迪至尊超极速™SDHC™/SDXC™ UHS-I 存储卡
        • 闪迪至尊极速™ SDHC™/SDXC™ UHS-I 存储卡
        • 至尊高速 SDHC/SDXC 存储卡,读取速度高达 80MB/s | 闪迪
        • SDHC/SDXC 存储卡 | 闪迪
      • microSD 存储卡 | 闪迪
        • 闪迪至尊超极速移动 microSD UHS-I 存储卡
        • 至尊极速移动 microSD UHS-I 存储卡加强版 A1 | 闪迪
        • 至尊极速移动microSDXC/microSDHC UHS-I 存储卡 | 闪迪
        • 至尊极速移动 microSD 存储卡| 闪迪
        • 适用于运动相机的闪迪至尊极速移动 microSD 存储卡 | 闪迪
        • 至尊高速移动 microSD 存储卡,读取速度高达 95MB/s | 闪迪
        • 适用于相机的闪迪至尊高速移动 microSD UHS-I 存储卡
        • 闪迪移动microSD 存储卡
        • 闪迪高度耐用的视频监控 microSD 存储卡
        • 至尊高速移动 microSD UHS-I 存储卡,读取速度高达 48MB/s | 闪迪
        • 至尊高速移动 microSD 存储卡(适用于智能手机) | 闪迪
        • 至尊超极速移动 microSDXC UHS-II 存储卡 | 闪迪
        • 闪迪至尊高速移动 microSDXC 存储卡加强版 | 闪迪
        • 至尊高速移动 microSDXC | 闪迪
        • Nintendo Switch 专用闪迪 microSDXC 存储卡
        • 闪迪至尊极速 microSDXC 存储卡 | 闪迪
      • 紧凑型闪存卡
        • 闪迪至尊超极速™ CompactFlash® 存储卡
        • 闪迪至尊极速™ CompactFlash 存储卡
        • 闪迪至尊高速™ CompactFlash 存储卡
      • CFast 2.0 卡
        • 闪迪至尊超极速™ CFast 2D 存储卡
      • 读卡器
        • 至尊超极速 CFast 2.0 读卡器/写卡器 | 闪迪
        • ImageMate All-in-One USB 3.0 读卡器 | 闪迪
        • MobileMate Duo 适配器和读卡器 | 闪迪
        • MobileMate USB 读卡器 | 闪迪
        • 至尊超极速 SD UHS-II 读卡器 | 闪迪
        • 至尊超极速 SD UHS-II USB-C 读卡器 | 闪迪
        • ImageMate Pro USB 3.0 读卡器 | 闪迪
    • USB 闪存盘
      • 闪迪至尊极速USB 3.1 闪存盘
      • 闪迪至尊超极速 USB 3.1 固态闪存盘
      • 闪迪酷圈 USB闪存盘
      • 闪迪至尊高速酷铄™ USB 3.0 闪存盘
      • 闪迪至尊高速 USB 3.0 闪存盘
      • 闪迪至尊高速酷豆™ USB 3.0 闪存盘
      • 闪迪酷悠™ 3.0 USB 闪存盘
      • Cruzer Force USB 闪存盘 | SanDisk
      • 闪迪酷悠™ USB 闪存盘
      • 酷轮 USB 闪存盘
      • 酷扭™ USB 闪存盘
      • 闪迪酷锁™ USB 闪存盘
      • 酷刃 USB 闪存盘
      • 酷捷 USB 闪存盘
      • 闪迪酷豆 USB 闪存盘
      • 闪迪至尊高速酷豆™ USB 3.1 闪存盘
    • 固态硬盘
      • 闪迪至尊极速™ 900 型移动固态硬盘
      • 闪迪至尊极速 510移动固态硬盘
      • 闪迪至尊极速™ 500 型移动固态硬盘
      • 闪迪至尊高速mSATA固态硬盘
      • 闪迪至尊超极速™ 固态硬盘
      • 闪迪至尊高速™固态硬盘
      • 闪迪固态硬盘加强版
      • 闪迪固态硬盘笔记本电脑升级工具套件
      • 闪迪至尊高速 3D 固态硬盘
      • 闪迪至尊高速 3D 固态硬盘重新定向
      • 闪迪至尊极速 便携式固态硬盘
      • 闪迪至尊超极速™ M.2 NVMe 3D 固态硬盘
    • 至尊极速团队
      • Steve McCurry
      • Akito Mizutani
      • Walter Iooss
      • Elizabeth Kreutz
      • Tom Bol
      • Lucas Gilman
      • Marcelo Maragni
      • Jeff Lewis
      • Corey Rich
      • Christian Pondella
      • Caio Guatelli
      • Terrell Lloyd
      • Michael Grecco
      • Akash Das
      • Kaustav Saikia
      • Mahryska 和 Tinayums
      • Amy Tierney
      • Alex Liu
      • Scott A. Woodward
      • Steve Simon
      • Kike Calvo
      • C.S. Ling
      • Peter Eastway
      • Cliff Mautner
      • Bambi Cantrell
      • Bob 和 Dawn Davis
      • Zach 和 Jody Gray
      • Marcus Bell
      • Sam Nicholson
      • Richard Finn Gregory
      • Vincent Laforet
      • Sebastien Devaud
      • Paolo Baccolo
      • Phil Coates
      • David Newton
      • Daniel Fox
      • Fred Pompermayer
      • Christian Nørgaard
      • Kirill Umrikhin
      • Matthew Jordan Smith
      • Richard Walch
      • Marcel Laemmerhirt
      • Dom Daher
      • Joao Carlos
      • Claudia Goetzelmann
      • Patrick Bellair
      • Wendell Phillips
      • Tyler Stableford
      • Jonathan & Angela Scott
      • Ellen Anon
      • Daisy Gilardini
      • Georg Tappeiner
      • George Karbus
      • Renan Ozturk
      • Lars Schwellnus
      • Tim Laman
      • Sean Scott
      • Nick Didlick
      • Dave Black
    • Stories
    • 购买地点
  • 商用
    • 数据中心
      • 产品
        • 闪存设备(非页面)
          • PCIe 闪存(非页面)
          • SSD (非页面)
        • 闪存软件(非页面)
          • 开源
          • ioVDI 软件
      • 解决方案
        • 数据库
        • 虚拟化
        • 大数据
        • 云解决方案
      • 合作伙伴
      • 资源库
        • Case Studies
        • Data Sheets
        • Overviews
        • FAQ
        • Report
        • Articles
        • Video
        • Solution Briefs
          • All-Flash Storage System for Ceph and OpenStack
          • Red Hat Ceph Storage on the InfiniFlash All-flash Storage Platform
          • The Solution for Cassandra at Scale | SanDisk
          • Storage for MongoDB Analytics
          • Optimizing Ceph Deployments Solution Brief
      • 博客
    • 计算
      • X600
      • X400
      • Z400s
      • sn720
      • sn520
    • 专业照片和视频
  • OEM 设计
    • 数据中心
    • 计算
    • 移动设备
      • iNAND 嵌入式闪存驱动器
    • Commercial
    • 工业原始设备制造商 (OEM) 设计解决方案
      • iNAND(内部存储器)
      • 工业存储卡
      • OEM 卡
    • 车载
      • 车载 SD 存储卡
      • 车载 iNAND
      • 车载 SD 存储卡
    • Connected Home
    • Blog
  • 关于闪迪
    • 备受信赖的品牌
      • 里程发展
      • 品牌优势
        • 企业
        • 消费类
      • 品牌多元化
      • 投资项目
    • 媒体中心
      • 新闻稿
        • 2017
          • SanDisk® Launches its Fastest, High-Capacity USB Flash Drive Ever
          • SanDisk® Unveils World’s First microSD Card Designed to Deliver a New Dimension of Mobile Application Performance
          • Western Digital Transforms the Mobile Experience with New ‘Smart’ iNAND 7350 Storage Solution Built on 3D NAND
          • SanDisk® Teams with Leading Manufacturers to Offer Consumers a Faster Mobile App Experience
          • SanDisk Now Offers 256GB of Extra Storage for iPhone and iPad
          • Western Digital Introduces iNand 7250a Embedded Storage Device For Evolving Data Demands Of Connected Automotive Technologies
          • Western Digital To Deliver World’s First Client Solid State Drives With 64-layer 3d Nand Technology
          • Western Digital gives consumers a unique, hassle-free solution for daily iPhone backup
      • Awards & Accolades
        • 太平洋电脑网 (pconline.com)
        • 太平洋电脑网 (pconline.com)
        • 电脑之家 (PCHome)
        • 电脑之家 (PCHome)
        • 中关村在线 (ZOL)
        • 中关村在线 (ZOL)
        • IT168
        • 天极网 (Yesky)
        • 天极网 (Yesky)
        • 天极网 (Yesky)
        • 天极网 (Yesky)
        • 电玩巴士 (TGBUS.com)
        • PCEVA
        • 三好街网 (Sanhaojie.com)
        • 52硬件网 (52hardware.com)
        • 电脑报 (PCW)
        • 电脑报 (PCW)
        • 电脑报 (PCW)
        • 电脑报 (PCW)
        • 电脑报 (PCW)
        • 新潮电子E-fashion
        • 新潮电子E-fashion
        • 数码影像时代 (Digital Video Times Magazine)
        • 数码摄影 (Foto Video)
        • 新电脑 (CHIP)
        • 新电脑 (CHIP)
        • 微型计算机 (Micro-computer)
        • 热点科技
        • 手机中国
        • 手机中国
      • 活动
        • Microsoft World Partner Conference
        • International Super Computing
        • Mobile World Congress Shanghai
        • Flash Memory Summit
        • Intel Developer Forum 2015
        • VMworld US
        • LinuxCon North America
        • SpiceWorld
        • VMworld Europe
        • VMworld Europe
        • GTEC
        • Oracle OpenWorld
        • HP Discover London
        • Gartner Data Center Conference
        • Photo Plus Expo 2015
        • Big Data Expo
        • SQL PASS Summit 2015
        • TigerDirect Innovation – IT Conference and Expo
        • Mobile World Conference
        • Embedded World
        • Open Compute
        • Linux Open Vault Conference
        • LinuxCon North America 2016
        • Western Digital: The Future of Data
      • 媒体资源
        • 产品
        • 企业
          • 管理团队
      • 洞察报告
    • 招聘信息
      • 为什么选择闪迪
        • 薪资和福利
      • 校园招聘
      • 职业发展
    • 世界公民
      • 社会
      • 环境
      • 社区
      • 奖学金
        • 奖学金获得者
      • 供应商管理
    • 投资者关系
    • 联系我们
  • 支持
    • iXpand Compatibility
  • 家用
  • 商用
  • OEM 设计
  • 关于闪迪
  • 支持
 
  • 数据中心
    • 计算
    • 专业照片和视频
  • 产品
  • 解决方案
  • 合作伙伴
  • 资源库
  • 博客

案例研究

Skills Inc. Provides Services and Skills to the Aerospace Industry with the Help of Dell and SanDisk DAS Cache

Skills Inc., one of Washington State’s largest aerospace suppliers, is a self-supporting, nonprofit enterprise that employs people of all abilities. When key reporting and analysis functions were being compromised due to the slow performance of their ERP system, the organization deployed SanDisk DAS Cache software for their Dell PowerEdge server, to get more utilization from their Fusion ioMemory PCIe card.

Solution Focus

  • Microsoft® SQL Server 2012
  • Information on Demand
  • Server virtualization

Summary of Benefits

  • 75% improvement in report processing time
  • Reduced points of failure

Products

  • Fusion ioMemory™ drive
  • SanDisk® DAS Cache
  • Dell™ PowerEdge™ R730xd server

Background

Skills Inc., one of Washington State’s largest aerospace suppliers, is a self-supporting, nonprofit social enterprise that employs people of all abilities in aerospace manufacturing, aerospace finishing, technical services, and business solutions. The organization’s mission is to create and maintain a stable and rewarding place of work, with an integrated and inclusive workforce, where persons with and without disabilities can contribute their skills. Skills Inc. generated revenue of $46 million in 2014, 99 percent of which was derived from their four lines of business, by competing in the open market.

Skills Inc. trains, employs, and serves people with disabilities by providing them with jobs, vocational programs, and services that offer opportunities to thrive at work and provide a much-needed service to customers and society. Through their four locations across Washington State, employees of Skills Inc. can participate in customized employment and vocational programs and aerospace internships.

Currently, Skills Inc. employs 650 persons, 60 percent of whom self-identify as having a medical, physical, learning, hearing, visual and/or mental disability. On-site interpreters assist those with hearing loss, while other staff assist with job and life skills coaching. “Success for us is training an individual well enough to be employed— at Skills Inc. or at another organization, such as Boeing,” said Ed Hammond, Senior Systems Administrator at Skills Inc. “We have translators on staff to work with our deaf employees and counselors to help employees understand what is expected of them. Some of them have never had a job before.”

 

The Challenge

The employment mission that the staff at Skills Inc. is striving for on a daily basis is critical to the well-being of their employees and customers. However, some of their key reporting and analysis functions were being compromised due to the slow performance of their Infor VISUAL manufacturing ERP system that was running on a Microsoft SQL Server database. “We were running huge complicated reports that would take a long time to run,” Hammond told us. “Sometimes these reports query massive tables that list more than 660,000 work orders that we have produced in the last decade, which are parts for Boeing or other aerospace suppliers. Other reports assist us in analyzing our profitability. They are critical to running the business. We needed to do something to improve performance.”

Running a report that needs to pore through every work order from the past five years or access each part number could take as long as 15 minutes before the system came back with data. “When these reports are run, it can be a problem for everybody else that is using the database,” explained Hammond. “We end up having to run those reports at night. For example, we have a Costing Utility that runs at night to calculate ERP costs and prepare account journals. This Costing Utility takes an hour to run every night. Although it doesn’t lock everyone out of the database, it certainly slows things down.”

The team considered a number of solutions to the performance issue. “We tried to run our workload on a SAN from another vendor that had an SSD cache on it. The company had touted the massive IOPS that the system would support. However, with only a one gigabyte network connection to the SAN, our other workloads were sucking up the cache on the SAN. We still weren’t getting the performance because we were sharing with other workloads,” said Hammond. “In addition, we run 24 hours per day and there were too many points of failure when storing our database on a SAN. Reducing the points of failure was critical for these processes that are crucial for our business. What I learned was that I would much rather have everything running on the box.”

“With SanDisk DAS Cache, I don’t have to think about it. I just turn it on and it works. It provides the performance I need and that’s worth a lot to me.”

Ed Hammond Senior Systems Administrator

The Solution

When visiting the TechEd 2014 conference in Houston, Hammond took a break from the technical training sessions to visit the SanDisk booth. “I saw a quote on the wall of the booth that said, ‘Our payroll batch went from two hours to 10 minutes and we thought something was wrong.’ And I thought, ‘That’s what I want.’” Hammond decided to buy a Fusion ioMemory PCIe card and test it. “I had been thinking about Fusion ioMemory PCIe cards for our SQL Server loads already, but was sold on the idea after I visited the booth.”

Hammond deployed the Fusion ioMemory PCIe card in the Hyper-V server that supported the SQL logs and database that he wanted to accelerate. While conducting some basic benchmarking, he immediately saw a performance increase. When Dell launched their 13G servers—which include SanDisk DAS Cache as an exclusive feature—Hammond recognized the opportunity to further improve utilization of the Fusion ioMemory PCIe card. “The reports that execute database queries hit pretty large tables and can negatively affect performance,” explained Hammond. “When we heard about SanDisk DAS Cache, we thought that might solve our issue. I was pretty excited about the possibility of using that one Fusion ioMemory PCIe card to accelerate the entire Hyper-V server instead of just a single database.” The organization was pleased with the reasonable price of the SanDisk DAS Cache software for their Dell PowerEdge server, in light of its ability to get more utilization from the internal Fusion ioMemory PCIe card.

SanDisk DAS Cache is an application acceleration solution using direct attached storage—for deployment in select thirteenth generation, FX2, and R920 Dell PowerEdge servers—which is sold, serviced, and supported by Dell. Designed to improve server utilization and workload performance, SanDisk DAS Cache is ideal for workloads, such as ERP and analytics, to reduce latency and improve I/O performance within existing database environments.

The IT team procured a flexible and scalable Dell PowerEdge R730xd server with SanDisk DAS Cache software and installed the Fusion ioMemory PCIe card. “I was surprised by how easy it was to set up,” said Hammond. “Even when I make changes to the server, disabling and re-enabling SanDisk DAS Cache is a snap. And there is no risk of data loss. “

The team has licensed all eight cores on the Dell PowerEdge R730xd server for SQL Server and they run SharePoint Enterprise, as well as the main database that hosts the ERP system. Two virtual SQL servers are clustered with SQL Server 2012 AlwaysOn so that the ERP reports can be run against a secondary read-only database.

Skills Inc. leveraged their relationship with Dell to deploy the new server and software. “We received stellar assistance from the Dell sales engineers. We ran some utilities from Dell on the server for a couple of days to determine our performance, I/O usage, and the best solution going forward. I had already purchased the Fusion ioMemory card, but I was blown away from what I learned from the Dell tools.”

 

The Result

Since implementing the new Dell PowerEdge R730xd server equipped with SanDisk DAS Cache and Fusion ioMemory PCIe cards, the standard reporting run by the Skills Inc. team has improved significantly. “What is great is that I don’t have to manage it,” said Hammond. “I used to have to make sure that the logs and databases didn’t grow beyond the allocated space. I knew what I was paying per gigabyte and was continuously monitoring how much I could fit on a device. Now, the system just handles it. Maintenance has been easy.” The database has reached more than 38GB, a ten-fold increase over the past decade. “With SanDisk DAS Cache, I don’t have to think about it. I just turn it on and it works. It provides the performance I need and that’s worth a lot to me.”

In addition, the 4TB of back-end storage within the architecture has improved performance as well. Skills Inc. has seen acceleration in 94 percent of the writes and 43 percent of the reads to and from the database storage.

“Once we started using SanDisk DAS Cache, everything started running much faster,” said Hammond. For example, database log reports indicate that the Costing Utility report typically took close to an hour to run every night prior to the implementation of the new architecture. Once the Dell servers, SanDisk Das Cache, and Fusion ioMemory card were deployed, the process averaged just 15 minutes to run—a 75 percent improvement.

Average Log Time to Run Costing Utility

With SanDisk
15.25 minutes
Without SanDisk
60.5 minutes
75%
Improvement

“This was a great solution for us,” Hammond concluded. “Having all of those systems running on this one piece of hardware with SanDisk DAS Cache provides me with the acceleration for the ERP and for the SharePoint, unlike for just the one database.“

Footnotes

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

Skills Inc. Provides Services and Skills to the Aerospace Industry with the Help of Dell and SanDisk DAS Cache
Download

准备好借助闪存技术继续前进了吗?

不论贵公司是财务五百强企业还是五人小创业公司,闪迪都能提供适合您的解决方案,帮助您充分利用现有基础架构。

在线
咨询

欢迎向我们提问,我们会尽快回复您。

全球销售
联系人

查找全球办事处的联系方式。

客户
关怀

对您购买的产品有疑问? 我们可以提供帮助!

销售咨询

如果您有任何疑问或者想要讨论根据贵公司需求定制的闪迪解决方案,闪迪销售团队可随时为您提供帮助。

我们会竭诚回答您的问题。请填写下表,以便我们提供帮助。

字段不能为空。
字段不能为空。
请输入有效的电子邮件地址。
字段不能为空。
字段不能为空。
字段不能为空。
字段不能为空。

请指出您感兴趣的领域:

您必须选择一个选项。

问题或评论:

隐私政策

谢谢!我们已收到您的请求。

网站菜单

  • 家用
    • 移动存储
    • 读卡器
    • USB
    • 固态硬盘
    • MP3播放器
  • 商用
    • 数据中心
    • 计算
    • 合作伙伴
    • 专业相片 & 视频
  • OEM 设计
    • 移动设备
    • 计算
    • 车载
    • 互连家庭
    • 工业 & 其他
    • 数据中心
  • 媒体中心
    • 新闻稿
    • 奖项和荣誉
    • 媒体资源
  • 招聘信息
  • 投资者关系
  • 联系我们

支持部

  • 业务支持
  • 零售支持

快速链接

  • IT 博客
  • 渠道合作伙伴门户
  • 闪迪故事
  • 至尊极速团队

IT 博客

Post Thumbnail

{{feed.title}} | {{getFormattedDate(feed.publishedDate) | date:''}}

阅读更多信息 »
  • 法律事务
  • 使用条款
  • 商标
  • 隐私声明
  • Cookie
  • Taiwan BSMI RoHS
  • 关于广告
  •  
闪迪
© 2018 Western Digital Corporation 或其关联公司版权所有。保留所有权利。