Post reply

Partitioned Table on same physical volume performance

  • July 2, 2014 at 3:03 pm

    #293049

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

  • July 2, 2014 at 3:07 pm

    #1726640

    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

  • July 2, 2014 at 3:10 pm

    #1726641

    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.

  • July 2, 2014 at 3:41 pm

    #1726646

    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