It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Enabling Flash to Support Mission-Critical Applications

In many cases, the performance of applications using SQL Server is limited by storage performance so it is easy to understand the popularity of flash storage. With AlwaysOn Availability Groups, Microsoft® has enabled non-SAN storage to support application failover from a primary to a secondary server. Log shipping with synchronous-commit to a secondary replica emphasises high availability and data protection, but often at the cost of increased transaction latency. Testing by LSI has shown that using a dedicated network with synchronous-commit, the LSI® Nytro™ MegaRAID® Application Acceleration card provided up to an 80X improvement in user response times over just using HDDs under an OLTP workload.

In this session by Mike Horner, LSI Senior Field Applications Engineer, we will discuss how using flash with intelligent caching can allow an economical mix of flash and HDDs to be used because typically only a small portion of storage is accessed frequently, and retaining this data on flash can still provide huge performance gains. Nytro acceleration products support AlwaysOn and Windows Server® Failover Clustering which allows enterprise-class high availability to be supported.

Your browser does not support HTML5 and the Video tag. Please use the download links above.

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years and have all been given the MVP award by Microsoft