Partitioned Table on same physical volume performance

  • Is there any real advantage having a partitioned table with all files groups on the same disk?

  • Sliding window, fast deletes (of entire partition of data), index rebuilds at the partition level.

    Partitioning's not usually about performance in the first place.

    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
  • GilaMonster (7/2/2014)


    Sliding window, fast deletes (of entire partition of data), index rebuilds at the partition level.

    Partitioning's not usually about performance in the first place.

    Thanks Gail. For those benefits do you have to enable partition level locking? From my understanding that locking level is not enabled by defaulty.

  • No, you don't.

    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

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

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