Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 551
  • Last Modified:

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
0
bibi92
Asked:
bibi92
  • 3
  • 2
1 Solution
 
Randy Knight, MCMCommented:
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
 
bibi92Author Commented:
Thanks but is it possible to align volume disk.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Randy Knight, MCMCommented:
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
 
Randy Knight, MCMCommented:
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now