Topic: How SQL the server works with a disk?
There was a question: what portions of data SQL exchanges with a disk.
In subconsciousness the digit 64 but when tried to find its substantiation could not sits:
- At Microsoft found such articles:
From which explicitly does not follow, what even read operations are fulfilled by units on 64 - is told only that operation dataful happens at level of pages - i.e. 8. Also there is an advancing reading which can read to 512 for time, but a minimum probably 8, instead of 64, at least at reading of indexes.
Operation possibly happens to a broad gull in smaller portions - on one record.
Share, if know, clever articles from MS where more accurately describe a physical disk swapping, and whether it is possible to influence any adjustments the size of portions of a disk swapping?
p.s. The question arose on 2012 versions, but I think with 2000-2005 a little that changed in this part.
That does not become, all to the best.