A customer has 135 GB Microsoft SQL 2016 database deployed on an HPE ProLiant DL380 Gen10 server on direct attached storage. The customer would like to dramatically improve the database performance.
What should you propose?
A customer has 135 GB Microsoft SQL 2016 database deployed on an HPE ProLiant DL380 Gen10 server on direct attached storage. The customer would like to dramatically improve the database performance.
What should you propose?
To significantly improve the performance of a Microsoft SQL 2016 database deployed on an HPE ProLiant DL380 Gen10 server, using NVDIMMs (Non-Volatile Dual In-line Memory Modules) is the most suitable choice. NVDIMMs can dramatically enhance database performance by combining the speed of DRAM with the persistence of NAND, providing a fast storage tier directly within the server’s memory architecture. This allows for quicker access times and better performance for database operations compared to traditional storage solutions.
HPE Persistent Memory as a fast storage tier on HPE ProLiant Gen10 servers supporting second-generation Intel Xeon Scalable processors has a compelling value proposition for accelerating analytic workloads and other database workloads in general. Combined with Microsoft’s SQL Server 2019 release that enables an In-Memory Database design strategy for Persistent Memory, customers can realize significant improvements in performance. https://www.hpe.com/us/en/collaterals/collateral.a50000414.HPE-Reference-Architecture-for-Microsoft-SQL-Server-2019-Standard-Edition-on-an-HPE-ProLiant-DL380-Gen10-with-HPE-Persistent-Memory.html?rpv=cpf&parentPage=/us/en/products/servers/persistent-memory
Correct answer is C.