Viewing 5 posts - 1 through 5 (of 5 total)
I like this image of the Windows storage driver stack.
https://i-technet.sec.s-msft.com/dynimg/IC347746.gif
The allocation unit is an attribute of the filesystem, governing initial the incremental filegrowth possible.
Although its old, I like...
July 27, 2016 at 2:53 pm
Unless a test stresses the metadata differences or potential file interleave/contiguity differences between 4k and 64k au, I'd expect no measurable difference in a disk IO test.
For example, with a...
July 27, 2016 at 9:55 am
The allocation unit size has much less effect on size of SQL Server IO than is commonly believed.
Consider writes to the transaction log. Each write is a minimum of 512bytes...
July 27, 2016 at 7:59 am
What is the transaction log setup like? EG each txlog on its own LUN, or do any of the txlogs share with other files?
There are 128 transaction log buffers...
September 1, 2015 at 12:26 pm
We've watched trace flag 8048 go into numerous systems now, and have not observed any negative effects. We've been watching stolen memory, all waits and spinlocks in 5 minute...
April 18, 2013 at 8:11 pm
Viewing 5 posts - 1 through 5 (of 5 total)