Hi,<BR><BR>Suppose a dedicated SQL Server is having a disk bottleneck problem (very high disk read queue length on the data file drive). And if the data file is relatively small (25GB) and does ...

In Azure, the VM size is large. We attach a disk for SQL Data, SQL Log, and SQL Archive. According to Microsoft best practices, we format SQL Data and SQL Log to NTFS with an allocation unit size ...