sherriekubis

Block size for SQL Server geodatabases

Discussion created by sherriekubis on Oct 26, 2017
Latest reply on Oct 26, 2017 by sherriekubis

Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)   Oct 28 2016 18:17:30   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor) 

 

I have separate drives from C through K, for system, datafiles, logfiles, tempdb, etc.  Our database server is a VM, and the storage I am presented is from the underlying SAN storage of the VM.  The drives were created with the MS default of 4K, but it has been suggested to me that our datafiles, logfiles and tempdb should have a block size of 64K.  I don't see many references to this, nothing in ArcGIS documentation.  

 

I suspect the answer is 'it depends' on data size and use. 

 

Does anyone have any insights, experience, rules of thumb for this? 

 

Sherrie 

Outcomes