Partitioning Best Practice Advice

• Lou

  SSCrazy

  Points: 2929

  More actions

  October 4, 2019 at 1:10 pm

  #3686022

  Dear  Colleagues,

  As a best practice recommendation, defining table partitioning,

  Always keep empty partitions at both ends of the partition range. Keep the partitions at both ends to guarantee that the partition split and the partition merge don't incur any data movement. The partition split occurs at the beginning and the partition merge occurs at the end. Avoid splitting or merging populated partitions. Splitting or merging populated partitions can be inefficient. They can be inefficient because the split or merge may cause as much as four times more log generation, and may also cause severe locking.

  Does this means, that I should leave an empty filegroup at both ends of our database, with the same size, as others FileGroup partitions ? I could use the Primary FileGroup as our left empty partition ? Usually, How does it is implemented ?

  Thanks for your comments

   

   

  • This topic was modified 5 years, 1 month ago by  Lou.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  October 5, 2019 at 2:10 pm

  #3686238

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.