Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Thursday, November 16, 2017

Implications of slower writes with 64K pages using SSDs vs SAN

SQLServerCentral » Latest topics
Implications of slower writes with 64K pages using SSDs vs SAN
As part of our migration to SQL Server 2017, we are considering a move to local SSDs.  Some testing with DiskSpd.exe whowed that all IO types are faster with local disk for 8K IOs, but writes are slower for 64K IOs.  Here's how it tested out:

No comments: