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

  • 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

  • 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".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

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

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

  • 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

  • Hollyz (11/9/2015)


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

    I got the same impression on my screen.

  • 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".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

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

  • Thank you guy's for the feedback ??

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

  • 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

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

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