SQL Server Best Practices on Flash Series

SQL Server Best Practices on Flash Series

As my colleagues and I at the SanDisk® Data Propulsion Lab (the home of application performance on flash) travel and speak in venues around the world, we’re struck by a hunger for validation of best practices for SQL Server.

I’ve long evangelized the importance of fundamentals. Flash can seem like a magic bullet—it can mask many performance, configuration, and design challenges. Yet best practices remain fundamental. There is no substitute for engineering discipline in terms of application & database design. I often open my presentations with the following:

If you don’t have time to do it right, when will you have time to do it over?
—John Wooden

Our team has a multi-faceted plan to remediate this deficit and help you make the best of flash and SQL Server.

Two New Initiatives

I want to share with you two initiatives:

  • A series of practical, SQL Server best practices blog posts to help you take advantage of our lessons learned on flash. I’ll discuss Optimizing Power Settings in my first post.
  • A SQL Server on Flash webinar where I’ll share configuration best practices for the hardware, Windows, and SQL Server.  I’ll emphasize best practices for all implementations & highlight considerations specific to flash.

In addition, we’re incubating some exciting plans for additional presentations in collaboration with our friends at Microsoft. Stay tuned for that announcement!

Part 1: Best Practices

In the meantime, I invite you to join our forthcoming webinar:

What: SQL Server on Flash | Part 1: Best Practices
Who: Jimmy May
When: December 16, 2015
Where: On demand here

Jimmy May Webinar Invitation

Let us know in advance if you have any questions we can cover for you in the comments below, or reach out to me directly at jimmy.may@sandiskoneblog.wpengine.com and @aspiringgeek on Twitter. We’re looking forward to your joining us!


Jimmy May: Jimmy is a SQL Server Certified Master and is a SQL Server Technologist with a passion for “flipping the /faster bit”.

Related Posts

SQL Server OLTP Consolidation – How to Get the Right S2D Caching Tier
SQL Server OLTP Consolidation – How to Get the Right S2D Caching Tier

How can you maximize your SQL Server OLTP Consolidation? Peter Plamondon looks at what you need to know about the caching tier and working set size to make SQL Server OLTP Consolidation, using Storage Spaces Direct, a success.

SQL Server 2008 EOS – a Perfect Storm for HCI and S2D
SQL Server 2008 EOS – a Perfect Storm for HCI and S2D

If you're in IT, you’re facing a change in server architecture and deployment with hyperconverged infrastructure; a change in storage architecture with software-defined storage, and another wave of SQL Server migration and consolidation with the [...]