none
Is it fine to reclaim large unused space from large content database in SharePoint 2013

    Question

  • Hi there,

    We are having one large content database with size 350 GB and hosting one large site collection with size 150 GB in live servers.

    We have to delete this large site permanently as we have backup of this site in dedicated separate content database. 

    So we plan to reclaim the unused space in this large content database post site removal.

    Is it recommended to reclaim the space from the content database?

    Will there be any performance issues be encountered post reclaiming the space?

    Thanks

    mercredi 13 juin 2018 14:25

Réponses

  • Generally if you're looking to reclaim whitespace in a database you don't want to do it unless there is a significant amount of free space you need to reclaim -- in this case, it certainly looks justified.

    You will want to consider leaving some whitespace, 5 - 10% for future growth purposes. You will also want to perform a reindex procedure post-shrink as the indexes are heavily fragmented during this process.


    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    mercredi 13 juin 2018 15:59
    Modérateur
  • Hi AK SPAdmin.

    Yes, it's fine to reclaim the space from the content database if that used space is not needed anymore and this will not cause performance issues later.
    If the site collection you're going to delete is very large, I'd recommend you to use the Remove-SPSite cmdlet with the -GradualDelete switch to make the deletion process gradually executed to use less system load; after completing this operation, use the Remove-SPDeletedSite cmdlet to completely free the space previously used by the deleted site collection.

    Bye.


    Luigi Bruno
    MCP, MCTS, MOS, MTA

    mercredi 13 juin 2018 15:09

Toutes les réponses

  • Hi AK SPAdmin.

    Yes, it's fine to reclaim the space from the content database if that used space is not needed anymore and this will not cause performance issues later.
    If the site collection you're going to delete is very large, I'd recommend you to use the Remove-SPSite cmdlet with the -GradualDelete switch to make the deletion process gradually executed to use less system load; after completing this operation, use the Remove-SPDeletedSite cmdlet to completely free the space previously used by the deleted site collection.

    Bye.


    Luigi Bruno
    MCP, MCTS, MOS, MTA

    mercredi 13 juin 2018 15:09
  • Generally if you're looking to reclaim whitespace in a database you don't want to do it unless there is a significant amount of free space you need to reclaim -- in this case, it certainly looks justified.

    You will want to consider leaving some whitespace, 5 - 10% for future growth purposes. You will also want to perform a reindex procedure post-shrink as the indexes are heavily fragmented during this process.


    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    mercredi 13 juin 2018 15:59
    Modérateur

  • Hi AK SPAdmin,

    If the reply is helpful to you, you could mark the reply as answer. Thanks for your understanding.

    Best regards,

    Sara Fan


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    jeudi 14 juin 2018 02:06
    Modérateur