Home Forums Database Design Hardware Moving to a SAN, but the sizing concept doesn't sound right.... RE: Moving to a SAN, but the sizing concept doesn't sound right....

  • SQLRNNR (12/7/2011)


    Yes on the 64K, get them to format as 64K clusters. If filestreaming with larger files, you may want larger cluster sizes.

    The spindles seems off.

    The local drive is far to small (Server 2008 R2 for instance will chew up most of that 50GB for just the OS).

    More spindles would be a far better idea.

    I hear both of ya!! :crying:

    I'll keep trying to talk those folks into more spindles and much larger local drives (the fact they still didn't answer my memory dump related question counts for our group I guess...).

    I'll also insist on the 64K setting. Thanks to both of you for bringing that up!

    Right now nothing is ordered yet. Fortunately. I might need to get management involved if we can't reach an agreement. Seems like it's becoming a "battle zone" requiring a little more attention... 😎

    If I can't "win the battle" before the metal & fibre get installed, I'll do a little stress test (well, I'll do it anway...). If they can prove me wrong, I'd be happy... (sort of, at least)



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]