We have installed dedicated SSD drives for TempDB
- First question - should these drives be formatted with 64 Kb allocation size ? Currently it shows 4 Kb (Bytes per Cluster = 4096)
Does TempDB benefit from 64 Kb unit size, or it can be left with default 4 Kb ?
- Second question - we have data and log files on a separate "virtual" volumes that SAN admin sliced before, those volumes are made from SAN RAID array, and show 4 Kb allocation unit size
We can not change allocation unit size for those volumes at this point. So if we change TempDB SSD drive to 64 Kb, and data/log volumes stay as 4 Kb, will it cause any trouble for the SQL Server ?