• https://support.microsoft.com/en-us/kb/3009974 requires trace flag 1800 to be enabled. 18 hundred-level trace flags are likely to impact the storage engine (http://www.sqlservercentral.com/articles/trace+flags/70131/). I doubt tracestatus(1800,-1) will work (I suspect the storage engine has to be initialized with TF 1800 as a startup parameter). I assume trace flag 1800 reorders Windows API calls made by the storage engine (in sqlservr.exe). I suspect 1800 impacts handling the API call to fetch physical sector size and the API call to fetch the emulated sector size (so that SQL Server can quickly perform sector-aligned writes).