Nytro server-side flash cards work in unison with SQL Server 2014; deliver performance to fully enable benefits of new Buffer Pool Extension feature
SAN JOSE, Calif., April 24, 2014 – LSI Corporation (NASDAQ: LSI) today announced that LSI® Nytro™ flash accelerator cards have been tested to help amplify the performance of SQL Server 2014. The development efforts between LSI and Microsoft bring together technologies to help businesses overcome I/O bottlenecks, accelerate SQL Server 2014 database transactions and extract the full value from data.
LSI Nytro flash cards are also being utilized in conjunction with the new SQL Server 2014 Buffer Pool Extension feature to provide the low latency, high throughput and reliability required to fully enable the benefits offered by BPE technology.
“SQL Server 2014 enables customers to build mission-critical applications and big data solutions using high-performance, in-memory technology,” said Tiffany Wissner, Director Product Marketing, SQL Server Product Marketing, Microsoft. “By using SQL Server 2014 with LSI Nytro cards, our joint customers can achieve the performance requirements of their most demanding workloads in the cloud.”
“Microsoft tested LSI Nytro flash cards as a core component of SQL Server 2014 development, which is a strong endorsement of the performance and reliability of Nytro technology,” said Jas Tremblay, Vice President of Marketing, Datacenter Solutions Group, LSI. “Through our strategic relationship with Microsoft, we’re helping customers achieve the highest application performance for their most intensive I/O workloads.”
Microsoft tested LSI Nytro cards for SQL Server 2014 development efforts to meet the performance demands required to tune and optimize its features. Nytro cards satisfy Microsoft’s standards for building and testing SQL Server 2014 with the end result of high customer satisfaction and confidence knowing that critical and data-intensive workloads can achieve low response times with a high-performance and reliable solution.
Microsoft is also utilizing Nytro flash cards to fully enable the benefits offered by the SQL Server 2014 Buffer Pool Extension feature. Buffer Pool Extension provides database administrators with the option to increase transaction performance by utilizing non-volatile, NAND flash-based storage in order to extend the buffer pool size. The BPE feature functions as a level two (L2) cache, with the main buffer pool functioning as a level one (L1) cache. For workloads that consist primarily of frequently accessed reads, SQL Server 2014 will automatically transfer these data pages to the (L2) cache as necessary.
A simple alter server configuration command is used to specify the location and size of the file for the BPE feature. Nytro flash cards help to accelerate SQL Server 2014 workloads by placing this file on the Nytro card, improving transaction performance for read-intensive workloads when database working sets no longer fit into the main buffer pool (L1) cache.
The comprehensive LSI Nytro product portfolio of PCIe flash accelerators are designed to deliver high performance, reduced latency and a low CPU burden for the most demanding database applications and I/O-intensive workloads. The products are available from select LSI original equipment manufacturers and through the LSI worldwide network of distributors, integrators and VARs.
More information on LSI Nytro and SQL Server 2014 solutions is available at https://www.lsi.com/partners/storage-ecosystem/Pages/sql-server.aspx.
LSI Corporation (NASDAQ: LSI) designs semiconductors and software that accelerate storage and networking in datacenters, mobile networks and client computing. Our technology is the intelligence critical to enhanced application performance, and is applied in solutions created in collaboration with our partners. More information is available at www.lsi.com. Connect with LSI via Facebook, Twitter and YouTube.
LSI, the LSI & Design logo, Storage.Networking.Accelerated. and Nytro are trademarks or registered trademarks of LSI Corporation in the United States and/or other countries.
All other brand or product names may be trademarks or registered trademarks of their respective companies.