August 22, 2016 at 1:36 pm
Can SQL Server Engine write or retrieve from disk only a single page or is an extent retrieved/fully allocated regardless? This question came up when a very knowledgeable friend of mine told me that because the SQL Engine usually caches an entire extend and allocates extents regardless it's good practice to always format storage with 64KB block sizes. In my thought process, if the SQL engine is able to only write or retrieve a single page (without caching/allocating an extent) then there are scenarios where that wouldn't improve performance.
August 23, 2016 at 4:24 am
Yes it can, and that knowledgable friend is wrong, 64kb is not the ideal block size, SQL does not read and write in extents only.
http://blog.purestorage.com/what-is-sql-servers-io-block-size/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply