A peak underneath the hood
| Operation | IO Block Size |
|---|---|
| Transaction log write | 512 bytes – 60 KB |
| Checkpoint/Lazywriter | 8KB – 1MB |
| Read-Ahead Scans | 128KB – 512KB |
| Bulk Loads | 256KB |
| Backup/Restore | 1MB |
| ColumnStore Read-Ahead | 8MB |
| File Initialization | 8MB |
| In-Memory OLTP Checkpoint | 1MB |
Database Blog 