Post reply

Storage question

  • May 7, 2015 at 11:58 am

    #303721

    I have SSD storage of size 1TB, if I partition into multiple disks for tempdb, data, logs does it improve performance or not. I mean keeping in single disk vs multiple, dedicated disks would obviously improve performance since we partition from a disk into multiple would that improve or not or remain same.

  • May 7, 2015 at 1:17 pm

    #1796382

    mxy (5/7/2015)

    I have SSD storage of size 1TB, if I partition into multiple disks for tempdb, data, logs does it improve performance or not. I mean keeping in single disk vs multiple, dedicated disks would obviously improve performance since we partition from a disk into multiple would that improve or not or remain same.

    Quick thought, it is not going to make any difference. It could on spinners as partitioning can be used to reduce file fragmentation, with no moving parts the SSD make this less of an issue.

    😎

    Just remember to match the Extents and the NTFS Allocation Unit size, set the latter to 64KB.

  • May 7, 2015 at 1:55 pm

    #1796394

    Nope, it's still a single drive no matter how many pieces it's been split into.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 7, 2015 at 1:58 pm

    #1796396

    thanks to all for clearing my question 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

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