How to Add a Drive as a Clustered Physical Disk Resource in Windows

Question

How to Add a Drive as a Clustered Physical Disk Resource in Windows

gana20m

SSCrazy

Points: 2443
More actions
November 9, 2015 at 12:06 am

#312985

Comments posted to this topic are about the item How to Add a Drive as a Clustered Physical Disk Resource in Windows
Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003861 More actions · Answer 1

I hate it when people give an article 1 star without saying why. It gives no one the chance to improve or avoid. Incredibly, I've never had to do this because I've always worked with a Windows/Infrastructue Group so I can only say that it looks like a correct step-by-step procedure.

So, to all of you "one star cowards" that grade with no explanation, what's wrong with this article?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Hollyz SSCommitted Points: 1763 More actions · Answer 2

The display of the images are horrible. Can't follow along.

thierry.vandurme Hall of Fame Points: 3340 More actions · Answer 3

No one deserves 1 star so I gave 2. Why?

* windows 2003 is obsolete - in my opinion you should document the steps for 2008+

* you format the partition with the defaults. In windows 2003 you should use diskpart to align the partition to a 64K boundary for performance reasons. Win2008 does it automatically

* also if you format the disk for sql you should use 64K block size, again for better performance

* since you're using win 2003 you should talk about the fact that if you later want to modify the clustered resource you need to bring SQL offline. Not so with win 2008 where you can add/remove disks on the fly (assuming you're not messing around with disks that still have active db files on them)

* it may be interesting to also discuss the permissions for SQL if you have an instance installed and need to add a second disk. Since SQL is already installed the permissions will not be set automatically and you need to set ntfs permissions manually or you'll get access denied when creating a db on that new disk

Hope that clarifies my rating of 2 and hope it helps in writing future articles. Don't let the rating bring you down. Keep it up and maybe one day we'll be buying your book in a store 🙂

Chrz

Thierry

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

Hollyz (11/9/2015)
The display of the images are horrible. Can't follow along.

I got the same impression on my screen.

Jeff Moden SSC Guru Points: 1003861 More actions · Answer 5

Now we're talking. Thanks for posting some feedback, folks!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

gana20m SSCrazy Points: 2443 More actions · Answer 6

Thank you guy's for the feedback ??

Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 7

Yeah, the glaring omission is the Allocation Unit Size of 64k. I've seen this missed in far too many environments.

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg