Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kenneth Igiri The Real World: Fragmented Disk and High PAGEIOLATCH Waits RE: The Real World: Fragmented Disk and High PAGEIOLATCH Waits
M&M
SSC-Insane
Points: 21700
More actions
April 20, 2012 at 7:25 am
#1476619
and the default 4K allocation unit (instead of 64k), both of which could cause a single logical read to become multiple physical reads.
Is it possible to check the allocation unit using SQL ServeR?