- Community Home
- >
- Storage
- >
- Around the Storage Block
- >
- Bring Enterprise-Class Flash Performance to SQL Se...
-
- Forums
-
Blogs
- Hybrid Cloud
- Edge
- Data & AI
- Working in Tech
- AI Insights
- Alliances
- Around the Storage Block
- Behind the scenes at Labs
- Careers in Tech
- HPE Storage Tech Insiders
- Inspiring Progress
- IoT at the Edge
- My Learning Certification
- OEM Solutions
- Servers: The Right Compute
- Shifting to Software-Defined
- Telecom IQ
- Transforming IT
- HPE Blog, Austria, Germany & Switzerland
- Blog HPE, France
- HPE Blog, Italy
- HPE Blog, Japan
- HPE Blog, Russia
- HPE Blog, UK & Ireland
- Blogs
-
Quick Links
- Community
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Contact
- Email us
- Tell us what you think
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Aruba Airheads Community
- Enterprise.nxt
- HPE Dev Community
- Cloud28+ Community
- Marketplace
-
Forums
-
Blogs
-
Information
-
English
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Receive email notifications
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content
Bring Enterprise-Class Flash Performance to SQL Server with MSA 2042 Entry-Level Storage
A new Demartek report shows that the flash-accelerated HPE MSA 2042 powered by intelligent software can improve SQL Server business outcomes for SMBs affordably.
The relentless growth of flash storage
The market for all-flash storage arrays (AFAs) continues to grow explosively, with HPE reporting a 70% year-over-year 3PAR all-flash array (AFA) sales increase, for Q3161. Flash storage is enjoying mainstream adoption in the large enterprise market, delivering benefits across multiple workload scenarios such as Online Transaction Processing (OLTP), Data Warehousing and VDI.
Here comes flash-accelerated storage for SMBs
Weโre extending the benefits of flash-accelerated storage to small and midsized businesses with the introduction of the HPE MSA 2042 storageโwith a โdash of flashโ SSD storage coupled with software intelligence to economically deliver accelerated application performance and improved business outcomes. Read more about the new MSAโand what a little flash can do.
Now letโs explore how SQL Server database performance can be improved with this entry-level storage.
Why SQL Server 2016
Microsoft SQL Server has been at the heart of enterprise IT across its many generations, with a broad array of use cases spanning virtually all industry verticals. Gartner, in October 2015, assessed SQL Server as the industry leader for Operational Databases2 and the National Institute of Standards and Technology public security board has recognized SQL Server as the industryโs least vulnerable database3.
Adding to these accolades, SQL Server 2016 delivers value with its industry leading TCO4, making it a natural choice for the purposes of this test evaluation effort on HPEโs value-priced storage system.
Demartek SQL Server test report: a tale of two value-added MSA 2042 options
Recently, Demartek evaluated SQL Server 2016 performance using the MSA 2042 Storage system with standard 800GB (two 400GB SSDs) of built-in flash storage in two performance enhancing software configurations, available and enabled, at no additional cost:
- SSD read cachingโThe two embedded SSDs were deployed as Read Cache to improve random read performance.
- Performance auto tiering (included in the Advanced Data Services Software Suite)โThe MSA 2042 supports sub-LUN tiering and automated data movement between tiers. Three distinct tiers are supported with a performance tier with SSDs, a standard SAS tier with Enterprise SAS HDDs and an archive tier utilizing midline SAS HDDs.
The MSA 2042 automated tiering engine moves data between available tiers based on the access characteristics of that data. Frequently accessed โpagesโ will migrate to the highest available tier delivering maximum performance to the application (performance tiering).
Tiering provides benefits by using flash to accelerate write as well as read transactions.
Background and key results for the HPE MSA 2042 SQL Server Online Transaction Processing (OLTP) testing
The Demartek testing focused on measuring transactional aspects of storage performance for a real SQL Server 2016 OLTP workload, simulating a financial brokerage firm with customers who generated transactions related to trades, account inquiries and market research. With a focus on business outcomes, the key workload metrics measured included:
- Database transactions per second
- Latency improvement
In addition, traditional storage metrics of Throughput and Input Output Operations per second (IOPS) were also investigated.
Demartek reported the following results from its independent testing, shown in the two charts below:
Read caching
- Database transactions per second : +35%
- Latency reduction: 4.5x improvement
Performance tiering
- Database transactions per second: +60%
- Latency reduction: 11x improvement
Note: Demartek ran the benchmark for 24 hours to ensure a steady state for I/O and providing enough time for the SSD read cache to โwarmโ fully and for the tiering algorithm to migrate โhotโ data to the flash SSD storage tier.
The takeaways
Results from both read caching as well as performance tiering configurations demonstrated that not only was more real work accomplished (database transactions per second) but the user experience for the SQL Server application was significantly improved (I/O latency) as I/O service requests were completed in a fourth to a tenth of the time.
Solution highlights for Demartek study
- HPE MSA 2042 takes HPEโs flagship entry array (with nearly half-a-million units sold to date) and turbocharges it with 800GB of built-in SSD capacity plus an all-inclusive software suite that delivers enterprise capabilities, at a starting price under $10K. With flash acceleration, automated tiering and data protection features are now standard and price-reduced, making the MSA 2042 ideal if for SMB customers looking to accelerate SQL Server performance.
- HPE SN1100E Gen 5 16Gb Fibre Channel adapter from Emulex delivers up to 1.2 million IOPS on a single port, and a published MTBF of 10 million hours for guaranteed reliability and up time. The SN1100E also supports the Virtual Fibre Channel (VFC) feature in Microsoft Windows Server for virtualized SQL Server deployments. (NOTE: The Demartek report utilized the older HPE SN1000E 16Gb Fibre Channel, now replaced by the HPE SN1100E.)
- HPE SN6000B Fibre Channel switch (Brocade 6510), designed to enable greater flexibility and investment protection, scales from 24 to 48 ports and supports 4, 8, 10 or 16 Gb/s speeds in an efficiently designed 1U package. It offers low-cost access to SAN technology while providing "pay-as-you-grow" scalability to meet the needs of an evolving storage environment.
Why this is such good news for SMBs
As flash storage deployments continue to proliferate in large enterprises, the HPE MSA 2042 storage is a compelling and affordable solution for small and midsized businesses that offers built-in flash acceleration and enterprise data services right out of the box.
Now you can improve your SQL Server Database Performance with HPE MSA 2040 storage flash upgrades at entry-level cost.
Learn more on this topic
Demartek Report: Accelerating Database Workloads Using HPE MSA Storage with Built-In Flash
Blog: The New HPE MSA 2042: What a Little Flash Can Do
HPE MSA 2042 Storage data sheet
HP StoreFabric SN1100E 16Gb Dual Port Fibre Channel Host Bus Adapter
HPE SN6000B 16Gb 48-port/24-port Active Fibre Channel Switch
1 HPE CEO Meg Witman on Q3 2016 Results
2 Why Microsoft for your database management system
3 SQL Server 2016: The database for mission-critical intelligence
4 SQL Server 2016 is generally available today
Meet Around the Storage Block blogger Dinara Alieva, Solution Marketing and Alliance Manager, HPE Storage.
- Back to Blog
- Newer Article
- Older Article
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Receive email notifications
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content
- jhoney on: HPE and VMware: 19-year innovation partners
- maichedonganh on: See it in action: True hybrid cloud powered by HPE...
- Ed-Burke on: Getting smarter with HPE Education Services
- Gregg Machon on: You complete me: What is HPE Complete?
- HPEStorageGuy on: What is HPE Nimble Storage dHCI?
- HPEStorageGuy on: โGive me more. . . hyperconverged please!โ
- HPEStorageGuy on: Get your storage on at HPE Discover
- Zack Z on: Affordable data protection with HPE Apollo Servers...
- RogerVI on: Why now is the right time to implement data protec...
- HPEStorageGuy on: Customer delight and empathy drive next wave of co...
-
3PAR
367 -
3PAR Thursday
124 -
AI
1 -
all flash
138 -
Apollo
11 -
Archiving
13 -
array data services
8 -
Artifical Intelligence
1 -
backup
36 -
Big Data & Analytics
13 -
Bloggers
34 -
BlueData
5 -
BURA
24 -
BURA Sunday
109 -
chalktalk
49 -
Cloud Bank
13 -
Cloud Storage
20 -
Cloud Volumes
13 -
CommVault
1 -
Composable Infrastructure
9 -
Containers
16 -
ConvergedSystem
5 -
Customer
15 -
data protection
177 -
Data Security
4 -
dHCI
8 -
Discover Archives
154 -
Discover2019
16 -
EMC
9 -
entry storage
22 -
file storage
25 -
flash storage
115 -
Gartner
11 -
HCI
1 -
HPE InfoSight
1 -
HPE OneView
1 -
HPE Primera
1 -
HPE SimpliVity
1 -
Hybrid Cloud
37 -
hyper-converged
40 -
hyperconverged infrastructure
1 -
InfoSight
37 -
Intelligent Data Platform
4 -
Intelligent storage
11 -
IT infrastructure
1 -
Microsoft
21 -
MSA
23 -
Nimble Storage
91 -
Object Storage
13 -
OpenStack
5 -
Oracle
7 -
podcast
84 -
primary storage
1 -
Primera
15 -
ProLiant
13 -
RMC
58 -
SAN
2 -
SAP
15 -
SDS Saturday
56 -
secondary data
7 -
Security
3 -
SimpliVity
4 -
SMB
16 -
software defined storage
59 -
solutions
3 -
Storage
1 -
storage management
5 -
storage networking
16 -
storage news
86 -
StoreEasy
17 -
StoreEver
67 -
StoreFabric
21 -
StoreOnce
151 -
StoreOnce Catalyst
8 -
StoreOnce VSA
11 -
StoreVirtual
50 -
StoreVirtual VSA
38 -
Synergy
3 -
Tape
77 -
TechValidate
2 -
Veeam
33 -
VMware
50 -
VSA
19 -
Webinar
10 -
XP Disk Array
14
- « Previous
- Next »
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2019 Hewlett Packard Enterprise Development LP