Link to home
Start Free TrialLog in
Avatar of bibi92
bibi92Flag for France

asked on

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
Avatar of Randy Knight, MCM
Randy Knight, MCM
Flag of United States of America image

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/
Avatar of Seth Simmons
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

User generated image
Avatar of bibi92

ASKER

Thanks but is it possible to align volume disk.
I'm not sure I understand the question.
Avatar of bibi92

ASKER

Several volumes have been created on the same disk. Is it possible to align a volume and format each to 64 k. Thanks regards
ASKER CERTIFIED SOLUTION
Avatar of Randy Knight, MCM
Randy Knight, MCM
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial