format disk SQL 64K and performance issue

Hello,

How can I check if disk is formatted 64K?
If not, how can I do it?

Thanks
bibi92Asked:
Who is Participating?
 
Randy Knight, MCMPrincipal ConsultantCommented:
Interesting question.  I don't think I've ever tried.  Formatting your logical volumes to 64K should be easy but I'm not certain on the partition alignment.   My guess is it would destroy all the volumes.  

Realistically, if your partitions and volumes were created in Server 2008 or higher, you're probably fine.  But it's worth running the commands in the article to know for sure.
0
 
Randy Knight, MCMPrincipal ConsultantCommented:
This article written by one of my colleagues may help. It also discusses partition alignment which you should look at as well.

http://www.sqlsolutionsgroup.com/improve-io-performance/
0
 
Seth SimmonsSr. Systems AdministratorCommented:
How can I check if disk is formatted 64K?

open an elevated command prompt and type diskpart
type list volume and it will show all the volumes; find the volume number by the drive letter you want to check
type select volume x (replace x with the actual volume number)
type filesystems and it will show the allocation size

If not, how can I do it?

the volume will need to be formatted which means you will have to backup any data on that volume first
when you format the drive (right-click on the drive in explorer and select format), change the allocation unit size to 64k in the options

format
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
bibi92Author Commented:
Thanks but is it possible to align volume disk.
0
 
Randy Knight, MCMPrincipal ConsultantCommented:
I'm not sure I understand the question.
0
 
bibi92Author Commented:
Several volumes have been created on the same disk. Is it possible to align a volume and format each to 64 k. Thanks regards
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.