• scott.shaw (7/12/2011)


    I've posted my blog. I hope it helps.

    Yep, it helped feed my growing unease for implementing SMSQL.

    We're currently in the throes of carving up an aggregate for 4 db servers and I gotta say that there are no warm and fuzzies after reading through this thread. Nevertheless, I have a couple questions regarding configuration.

    1. Putting the TempDb on it's own volume. It was my understanding that the software snapshots all volumes so is this recommendation strictly to keep TempDb from being intermingled with UserDb snapshots? Since system dbs don't get snapshoted, what's the drawback of putting TempDb on the same volume?

    2. Two of our servers house single 4-5TB dbs. Both are made up of multiple filegroups so we're leaning toward creating separate volumes for each filegroup. Make sense?

    Any other observations using SMSQL with dbs in the multi-TB range would be appreciated.

    _____________________________________________________________________
    - Nate

    @nate_hughes