Browse by Tags

• clustersize
• indexes
• IO
• lun
• microsoft
• partition
• performance
• raid
• sql server
• technet
• testing
• tool

NTFS Cluster size - if changing the default cluster size on the disk is a good idea or not?
16 October 07 05:18 AM | SQL Master | 2 Comments   

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 Read More...

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

How to gain Disk related performance with few simple steps
30 July 07 07:24 AM | SQL Master | 4 Comments   

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 Read More...

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