Don't pay more for SharePoint Storage than you have to :-)

Published Feb 03 2022 12:35 AM 1,812 Views
Senior Member

Even though most of us likes Microsoft, on some days more than others, there are no reason why we should pay more than necessary.

 

As you might know each tenant is born with a 1 TB SharePoint Storage allowance. On top of that you get 10 GB per licensed user.

Unless you already have a retention policy or similar in place that will delete the content of your SharePoint Site Collections as the time goes by, you will eventually run out of free SharePoint Storage. At the time of writing additional SharePoint Storage is available in the admin center at $0.20 per GB per month.

 

First of all it is important to know how the total SharePoint Storage is calculated. In the screen shot below you see the version history of a fairly typical file. It has been updated and reviewed a few times and currently we have a total of 25 versions.

It has been difficult to find any documentation from Microsoft confirming this, but as far as I know Microsoft calculate the Storage for this file as each version multiplied by its size. So in this case our file is roughly 25 * 39 MB towards the Storage allowance. That is a lot. 

VersionHistory.png

So what can we do about it?

As usually there are a fair number of options:

 

A) Set up a Rentention policy that will delete some of the content. For some organizations this is not an option as per their Governance policies or fear that the policy might delete too much. 

 

B) Reduce the number of document versions saved  ( the default is 500 major versions). This will  often require that you have some kind of provision tools in place that will change the default value. The downside of this option is that you might be in a situation where you wish to restore an older version, but that version does not exist anymore.

 

C) Monitor the Site Collections for activity and enforce that the Owners of a Site Collection deletes any non essential documents once the Site Collection is no longer active. This Governance approach might work in some organizations, but I have yet to see it.

 

D) Monitor the Site Collections for activity and once it is no longer active the Archiving process starts. Depending on the requirements that could be something like:    

archiveprocess.png

 

Step number 2 can be omitted but is there to ensure that it will be possible to locate any version of a given document should the need arise.

 

The reason for not deleting the entire Site Collection once the documents have been copied to cheaper storage is to ensure that the organization will still able to see the Site Collection and the content. Often the Site Collection was used in a project or similar and the organization needs to store that fact that this project once existed.

There is also possible to extend the process by deleting the Read Only Site Collection after a few months or years.  

 

If you are thinking "Well this might save us some SharePoint Storage, but I have no idea how to verify it", the PnP Script Samples is the place to go:

storage savings report

 

This script will output a report showing how much Storage you can save per site collection.

 

#SharingIsCaring

parker.png

4 Comments
%3CLINGO-SUB%20id%3D%22lingo-sub-3108362%22%20slang%3D%22en-US%22%3EDon't%20pay%20more%20for%20SharePoint%20Storage%20than%20you%20have%20to%20%3A)%3C%2Fimg%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3108362%22%20slang%3D%22en-US%22%3E%3CP%3EEven%20though%20most%20of%20us%20likes%20Microsoft%2C%20on%20some%20days%20more%20than%20others%2C%20there%20are%20no%20reason%20why%20we%20should%20pay%20more%20than%20necessary.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20you%20might%20know%20each%20tenant%20is%20born%20with%20a%201%20TB%20SharePoint%20Storage%20allowance.%20On%20top%20of%20that%20you%20get%2010%20GB%20per%20licensed%20user.%3C%2FP%3E%0A%3CP%3EUnless%20you%20already%20have%20a%20retention%20policy%20or%20similar%20in%20place%20that%20will%20delete%20the%20content%20of%20your%20SharePoint%20Site%20Collections%20as%20the%20time%20goes%20by%2C%20you%20will%20eventually%20run%20out%20of%20free%20SharePoint%20Storage.%20At%20the%20time%20of%20writing%20additional%20SharePoint%20Storage%20is%20available%20in%20the%20admin%20center%20at%20%240.20%20per%20GB%20per%20month.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFirst%20of%20all%20it%20is%20important%20to%20know%20how%20the%20total%20SharePoint%20Storage%20is%20calculated.%20In%20the%20screen%20shot%20below%20you%20see%20the%20version%20history%20of%20a%20fairly%20typical%20file.%20It%20has%20been%20updated%20and%20reviewed%20a%20few%20times%20and%20currently%20we%20have%20a%20total%20of%2025%20versions.%3C%2FP%3E%0A%3CP%3EIt%20has%20been%20difficult%20to%20find%20any%20documentation%20from%20Microsoft%20confirming%20this%2C%20but%20as%20far%20as%20I%20know%20Microsoft%20calculate%20the%20Storage%20for%20this%20file%20as%20each%20version%20multiplied%20by%20its%20size.%20So%20in%20this%20case%20our%20file%20is%20roughly%2025%20*%2039%20MB%20towards%20the%20Storage%20allowance.%20That%20is%20a%20lot.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22VersionHistory.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344842i8A2A8A407E4DCBD3%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22VersionHistory.png%22%20alt%3D%22VersionHistory.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%225%22%3ESo%20what%20can%20we%20do%20about%20it%3F%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3EAs%20usually%20there%20are%20a%20fair%20number%20of%20options%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EA)%20Set%20up%20a%20Rentention%20policy%20that%20will%20delete%20some%20of%20the%20content.%20For%20some%20organizations%20this%20is%20not%20an%20option%20as%20per%20their%20Governance%20policies%20or%20fear%20that%20the%20policy%20might%20delete%20too%20much.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EB)%20Reduce%20the%20number%20of%20document%20versions%20saved%26nbsp%3B%20(%20the%20default%20is%20500%20major%20versions).%20This%20will%26nbsp%3B%20often%20require%20that%20you%20have%20some%20kind%20of%20provision%20tools%20in%20place%20that%20will%20change%20the%20default%20value.%20The%20downside%20of%20this%20option%20is%20that%20you%20might%20be%20in%20a%20situation%20where%20you%20wish%20to%20restore%20an%20older%20version%2C%20but%20that%20version%20does%20not%20exist%20anymore.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EC)%20Monitor%20the%20Site%20Collections%20for%20activity%20and%20enforce%20that%20the%20Owners%20of%20a%20Site%20Collection%20deletes%20any%20non%20essential%20documents%20once%20the%20Site%20Collection%20is%20no%20longer%20active.%20This%20Governance%20approach%20might%20work%20in%20some%20organizations%2C%20but%20I%20have%20yet%20to%20see%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ED)%20Monitor%20the%20Site%20Collections%20for%20activity%20and%20once%20it%20is%20no%20longer%20active%20the%20Archiving%20process%20starts.%20Depending%20on%20the%20requirements%20that%20could%20be%20something%20like%3A%3CSPAN%3E%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22archiveprocess.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344843i88EEC71AE1F4D20C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22archiveprocess.png%22%20alt%3D%22archiveprocess.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStep%20number%202%20can%20be%20omitted%20but%20is%20there%20to%20ensure%20that%20it%20will%20be%20possible%20to%20locate%20any%20version%20of%20a%20given%20document%20should%20the%20need%20arise.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20reason%20for%20not%20deleting%20the%20entire%20Site%20Collection%20once%20the%20documents%20have%20been%20copied%20to%20cheaper%20storage%20is%20to%20ensure%20that%20the%20organization%20will%20still%20able%20to%20see%20the%20Site%20Collection%20and%20the%20content.%20Often%20the%20Site%20Collection%20was%20used%20in%20a%20project%20or%20similar%20and%20the%20organization%20needs%20to%20store%20that%20fact%20that%20this%20project%20once%20existed.%3C%2FP%3E%0A%3CP%3EThere%20is%20also%20possible%20to%20extend%20the%20process%20by%20deleting%20the%20Read%20Only%20Site%20Collection%20after%20a%20few%20months%20or%20years.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CLI-WRAPPER%3E%3C%2FLI-WRAPPER%3E%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20thinking%20%22Well%20this%20might%20save%20us%20some%20SharePoint%20Storage%2C%20but%20I%20have%20no%20idea%20how%20to%20verify%20it%22%2C%20the%20PnP%20Script%20Samples%20is%20the%20place%20to%20go%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.blogger.com%2Fblog%2Fpost%2Fedit%2F7119061876194190386%2F7771120839402786486%23%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20data-original-attrs%3D%22%7B%26quot%3Bdata-original-href%26quot%3B%3A%26quot%3Bhttps%3A%2F%2Fpnp.github.io%2Fscript-samples%2Fspo-generate-sp-storage-savings-report%2FREADME.html%26quot%3B%2C%26quot%3Btarget%26quot%3B%3A%26quot%3B_blank%26quot%3B%7D%22%3Estorage%20savings%20report%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20script%20will%20output%20a%20report%20showing%20how%20much%20Storage%20you%20can%20save%20per%20site%20collection.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%23SharingIsCaring%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22parker.png%22%20style%3D%22width%3A%20522px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344844i6B083AC6DDF8F9F7%2Fimage-dimensions%2F522x680%3Fv%3Dv2%22%20width%3D%22522%22%20height%3D%22680%22%20role%3D%22button%22%20title%3D%22parker.png%22%20alt%3D%22parker.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-3108362%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EThis%20blog%20post%20will%20walk%20you%20through%20the%20potential%20challenges%20related%20the%20SharePoint%20Storage%2C%20and%20a%20few%20suggestions%20how%20to%20minimize%20your%20costs.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3108362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHow%20to%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3110252%22%20slang%3D%22en-US%22%3ERe%3A%20Don't%20pay%20more%20for%20SharePoint%20Storage%20than%20you%20have%20to%20%3A)%3C%2Fimg%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3110252%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Kasper%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20great%20article.%20The%20link%20for%20the%20sample%20you%20have%20provided%20seems%20to%20be%20an%20edit%20link%20and%20hence%20only%20works%20for%20yourself.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3111005%22%20slang%3D%22en-US%22%3ERe%3A%20Don't%20pay%20more%20for%20SharePoint%20Storage%20than%20you%20have%20to%20%3A)%3C%2Fimg%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3111005%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20about%20the%20bad%20link%2C%20it%20should%20be%20corrected%20shortly.%20In%20the%20meantime%20the%20link%20is%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpnp.github.io%2Fscript-samples%2Fspo-generate-sp-storage-savings-report%2FREADME.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpnp.github.io%2Fscript-samples%2Fspo-generate-sp-storage-savings-report%2FREADME.html%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3183552%22%20slang%3D%22en-US%22%3ERe%3A%20Don't%20pay%20more%20for%20SharePoint%20Storage%20than%20you%20have%20to%20%3A)%3C%2Fimg%3E%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3183552%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20far%20as%20I%20know%20-%20in%20version%20history%20only%20the%20changes%20are%20saved.%20So%20let's%20say%20you%20have%20an%20excel%20file%20with%20a%20bunch%20of%20data%20-%20and%20it%20takes%20100mb.%20If%20you%20change%20one%20cell%2C%20it%20will%20not%20create%20another%20100mb%20file%20in%20version%20history%2C%20but%20it%20will%20only%20keep%20information%20about%20this%20small%20change%20(I%20know%20it%20works%20for%20office%20files%2C%20but%20it%20was%20supposed%20to%20work%20for%20other%20types%20as%20well).%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20don't%20think%20it%20is%20as%20you%20mentioned%20so%20'Number%20of%20versions%20*%20file%20size'.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Feb 03 2022 03:51 AM
Updated by: