- Community Home
- >
- Servers and Operating Systems
- >
- Servers & Systems: The Right Compute
- >
- HPE announces Reference Architecture: SQL Server 2...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Receive email notifications
- Printer Friendly Page
- Report Inappropriate Content
HPE announces Reference Architecture: SQL Server 2019 Standard Edition with HPE Persistent Memory
Learn how Hewlett Packard Enterpriseโs new solution combining Microsoft SQL Server 2019 Standard Edition, the HPE ProLiant DL380 and HPE Persistent Memory provides multi-fold performance increase compared to Microsoft 2014 or older editions.
Big Data is clearly a disruptive technology. Every industry is feeling the impact, from harnessing fleet data in real time to Artificial Intelligence impacting sales teams to how data access impacts rural America. Todayโs hyper-connected digital age requires the speed of data access for more informed decisions that lead to better business outcomes. Businesses need solutions designed and built around the processes and applications that are at the core. The key is integrating a data ecosystem that allows you to generate new insights, yet allowing fast access to what you already know.
HPE collaborated with Microsoft to devise and support a database solution involving innovative hardware and software technologies to deliver a high-performance, low-cost database solution that allows you to harness your data. The solution combines the worldโs most secure industry standard server, the HPE ProLiant DL380 and HPE Persistent Memory with Microsoftโs SQL Server 2019 Standard Edition. With speeds closer to the memory and the non-volatility of storage, HPE Persistent Memory, available in 128, 256, and 512 GB capacities and featuring Intelยฎ Optaneโข DC Persistent Memory, can transform critical database analytics workload. As with byte-addressable storage media, persistent memory unlocks new levels of performance using Microsoft SQL Server 2019 to bring in new features and enhancements with native support for persistent memory.
Key highlights of the solution include:
- Gain up to a 16.5x improvement in decision support system (DSS) performance when upgrading from SQL Server 2014 Standard Edition running on an HPE ProLiant Gen8 Server to SQL Server 2019 Standard Edition running on an HPE ProLiant Gen10 Server with HPE Persistent Memory.
- Realize a performance improvement up to 3.6x with HPE Persistent Memory over current generation NVMe technology with SQL Server 2019 Standard Edition deployments.
- Achieve significant savings through reduced power and cooling requirements when upgrading from traditional low latency storage options to HPE Persistent Memory.
The database solution with HPE Persistent Memory accelerates IT performance by allowing customers to either place an entire database, or parts of a database, in persistent memory. The SQL Server Standard Edition limits the amount of memory used by the application. This limit does not apply to HPE Persistent memory. Therefore, one can reap all the benefits of a larger hybrid memory pool without the high cost of DDR, or hitting the application memory boundary limit. As a result, multi-fold performance gains are observed with a very cost effective solution.
Read the full reference architecture and learn how to optimize your Microsoft SQL Server 2019 with HPE Persistent Memory.
Innovative design leveraging the HPE ProLiant DL380 server
The HPE ProLiant DL380 Gen10 server is the industryโs most trusted compute platform and delivers the latest in workload-optimized performance, security, and management automation, backed by a comprehensive warranty. The HPE ProLiant DL380 Gen10 server is securely designed to reduce costs and complexity, featuring the First and Second Generation Intelยฎ Xeonยฎ Processor Scalable Family with up to a 60% performance gain1 and 27% increase in cores2, plus up to 3.0 TB of HPE 2933 MT/s DDR4 SmartMemory. It supports 12 GB/s SAS, and up to 20 NVMe drives, plus a broad range of compute options.
HPE ProLiant: The intelligent foundation for hybrid cloud
HPE ProLiant is the intelligent foundation for hybrid cloud, with its fresh, flexible, software-defined approach, delivering unmatched workload optimization, security, and automation --all available as a service.
Workload optimized
The foundational intelligence of HPE ProLiant transforms IT with insights that help optimize workload performance, placement, and efficiency, delivering better outcomes faster.
360-degree security
Already the worldโs most secure industry-standard server, HPE ProLiant provides an enhanced holistic, 360-degree view to security that begins in the manufacturing supply chain and concludes with a safeguarded, end-of-life decommissioning.
Intelligent automation
The intelligence built into HPE ProLiant simplifies and automates management tasks, establishing a solid foundation for an open, hybrid cloud platform enabled by composability.
Delivered as a service
HPE provides customers choice in how they acquire and consume IT. Beyond traditional financing and leasing, HPE offers options that free trapped capital, accelerate infrastructure updates, and provide for on-premises pay-per-use consumption.
HPE Persistent Memory Enables Data to be Stored, Moved, and Processed at Unprecedented Speed, Improving TCO.
HPE Persistent Memory, available in 128, 256, and 512 GB modules, features Intelยฎ OptaneTM DC Persistent Memory to approach the speed of traditional DRAM with the persistence of storage, ensuring high capacity, high performance, and ongoing data safety โ even in the event of an interruption in power due to an unexpected power loss, system crash, or normal system shutdown. HPE Persistent Memory modules are optimized for second-generation Intelยฎ XeonTM Scalable processors.
Microsoft SQL Server 2019 Standard Edition Continues to Evolve with the Modern Data Center
SQL Server 2019 continues the evolution of SQL Server, bringing new capabilities to the modern data ecosystem to better support and enhance data management and data-driven applications.
Enhancements in SQL Server 2019 fall into five main themes:
- Reason over data anywhere, including better integration with big data systems, and new connectors for data virtualization.
- Choice of language and platform, including more container scenarios, more supported platforms, and greater extensibility.
- Industry leading performance and security, including better performance, extensions to intelligent query processing, and additional features to support GDPR compliance.
- The only commercial database with AI built in, built-in machine learning is now supported in more scenarios, including machine learning in SQL Server on Linux, and support for machine learning in failover cluster instances.
- Enhancing SQL Server on Linux, bringing SQL Server on Linux closer to feature-parity with SQL Server on Windows, including support for transactional replication and distributed transactions.
For more information, please check out:
Footnotes:
1 HPE measurements: Up to 60% performance increase of Intel Xeon Platinum vs. previous generation E5-2600 v4 average gains of STREAM, LINPACK, SPEC CPU 2006 & SPEC CPU2017 metrics on HPE servers comparing 2-socket Intel Xeon Platinum 8280 to E5-2699 v4 family processors. Any difference in system hardware or software design or configuration may affect actual performance. April 2019.
2 Up to 27% cores increase of Intel Xeon Platinum vs. previous generation comparing 2-socket Intel Xeon Platinum 8280 (28 cores) to E5-2699 v4 (22 cores). Calculation 28 cores/22 cores= 1.27 = 27%. April 2019.
Tom Lattin
Hewlett Packard Enterprise
twitter.com/HPE_Servers
linkedin.com/showcase/hpe-servers-and-systems/
hpe.com/servers
Tom_Lattin
Meet HPE Blogger Tom Lattin. Tom is the Vice President and General Manager of the Hewlett Packard Enterprise Workload Optimized Solutions and Mass Market organization responsible for driving the P&L and market share position for HPE compute solutions and products in the mass market.
- Back to Blog
- Newer Article
- Older Article
- Dale Brown on: Going beyond large language models with smart appl...
- alimohammadi on: How to choose the right HPE ProLiant Gen11 AMD ser...
- Jams_C_Servers on: If youโre not using Compute Ops Management yet, yo...
- AmitSharmaAPJ on: HPE servers and AMD EPYCโข 9004X CPUs accelerate te...
- AmandaC1 on: HPE Superdome Flex family earns highest availabili...
- ComputeExperts on: New release: What you need to know about HPE OneVi...
- JimLoi on: 5 things to consider before moving mission-critica...
- Jim Loiacono on: Confused with RISE with SAP S/4HANA options? Let m...
- kambizhakimi23 on: HPE extends supply chain security by adding AMD EP...
- pavement on: Tech Tip: Why you really donโt need VLANs and why ...
-
COMPOSABLE
77 -
CORE AND EDGE COMPUTE
146 -
CORE COMPUTE
130 -
HPC & SUPERCOMPUTING
131 -
Mission Critical
86 -
SMB
169