DISKPART to create partitions for SQL server

[intelwizrd]

Reference article wrote by MR Denny

http://www.tek-tips.com/viewthread.cfm?qid=1382365&page=1

Question regarding the section mentioning aligning the data into 64 block sections.

The article says to use DISKPART and align the disk to 64. How do I accomplish this?

create partition primary offset=1

or

create partition primary offset=512

Any help with this would be much appreciated as the documenation does not seem to specify what it interprets the value given in the offset command as.



----------------------------
Josh
CCNA, MCSE 2003(in progress)

 

[mrdenny]

You want to use the align switch not the offset switch. align fixes the block issue. The offset leaves unused space in front of the partition, kind of like the way a new computer comes with an extra parition with the restore CD on it.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[intelwizrd]

I think I just found something similar in an Exchange optimization forum.

Would I use

create partition primary align=32

or

create partition primary align=64

I dont know how to check the disk geometry in 2003 since diskpart does not seem to have all the functionality of diskpar in 2000.

----------------------------
Josh
CCNA, MCSE 2003(in progress)

 

[mrdenny]

I'm not sure where that information would be displayed. Check te DETAIL command. That may have what you are looking for.

Exchange folks should be using the same command as it's an issue global to the x86/x64 platform not databases.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com