Question

Buenas

tengo un server con windows 2003 y con discos locales y discos de SAN que se conectan por medio de tarjeta HBA.

El sistema operativo ve todos los discos correctamente, pero deseo formatear un disco en tamaños de bloque de 64kb pues es lo recomendado ya que voy a trabajar SQL en ellos.

he dado click derecho format a 64kb pero no toma los cambios, he ensayado con diskpart pero tampoco ( o no he dado bien el comando)

quisiera su ayuda, muchas gracias

Answer 1

Hola Janasdrua,

Windows Server 2003 and Earlier

Partitions created on versions of Windows up to and including Windows Server 2003 by default are not aligned. Partition alignment must be explicitly performed.
System Drives

System drives in versions of Windows prior to Windows Server 2008 cannot be aligned. Fortunately, workloads associated with system partitions of dedicated SQL Server computers are typically not as sensitive to partition misalignment as disks dedicated to I/O intensive uses, for example, SQL Server database files from which high-performance is demanded. As described in the “Appendix”, modern disks are proprietary “black boxes” and disk partition alignment does not enhance performance for individual disks; however, cache line misalignment may still apply. Make certain that performance thresholds, particularly disk latency, are not exceeded for all disks, including those on which the operating system and SQL Server data and log files reside.

Aqui te dejo todo el proceso,

http://blogs.technet.com/b/virtualpfe/archive/2011/08/08/hyper-v-virtual-machine-vm-partition-alignment.aspx

Saludos.