Browse by Tags

NTFS Cluster size - if changing the default cluster size on the disk is a good idea or not?

Published 16 October 7 7:18 AM | SSQA.net

You might have come across on the web resources that setting the disk to a 64k cluster size (8 * 8KB pages) might achieve the performance. But have you wondered will this really boost the disk performance, see in what scenario such as lots of reads and...

Filed under: sql server, performance, microsoft, technet, disk, partition, testing, hardware, lun, clustersize

How to gain Disk related performance with few simple steps

Published 30 July 7 9:24 AM | SSQA.net

Within your SQL Server environment there are few simple steps you can take up in order to gain performance to a level, for instance when configuring a SQL Server that will only contain a few gigabytes (GB) of data and not sustain heavy read nor write...

Filed under: sql server, performance, indexes, microsoft, disk, IO, testing, raid, hardware, tool