When is 1MB not 1MB?

Background

I’ve recently been working on a OneDrive for Business migration for a client to relieve them of the on-premises infrastructure. This client has home drives stored on NTFS shares which were mapped at logon and were for personal files only.  Because of the strict use, these file shares were limited to 500MB to ensure that any transactional data was stored elsewhere and not hidden away for personal use.

Configuring the storage quota in the OneDrive for Business Admin Centre for 500MB is not possible as the allowance is only configured in 1GB increments as shown below.

ODfB_Admin_CentreEven using the “Set-SPOSite -StorageQuota” PowerShell parameter has the same restriction so the minimum we could set for the client was twice the preferred size.  This shouldn’t be a problem providing a company policy is still followed to store non-personal documents elsewhere.

As part of a OneDrive for Business pilot, we moved users’ data from the NTFS shares to the client’s tenant, 115 users altogether. For this we used the SharePoint Migration Tool (available for download here).

Everything went well during the copying of data; the file shares were set as read-only, and the tool was run overnight to ensure minimal disruption to the users.  Before users arrived the next morning, the original file shares were disconnected from the login scripts and users were provided information on where their files were now located.  For the first couple of days, there were no complications until one of the users reported that they had run out of storage space.

Looking at the storage metrics (_layouts/15/storman.aspx) for the user’s OneDrive for Business they had in fact reached the 1GB limit set at the tenant.

Storage_Metrics1

This took us by surprise, as we were provided a list of users who were exceptions to the 500MB limit, but this user had appeared to be omitted from the list.  To validate, I looked at the user’s existing file share to confirm the actual amount of data prior to the migration and found the following;

File_Share1

So, the data was nowhere near the size to indicate that there would be a storage issue with a 1GB quota so something else must be going on.  After looking at the storage metrics in more detail I could see that the file size shown to the user did not match up in many cases with that reported by the storage metrics.

Picking a migrated file at random I can see in that one of the migrated docx files has a file size of 1.38MB.

Migrated1

Looking at the original file share this appears on disk as 1,415KB, so the file size is comparable after a migration.  Remember this is from an existing file share, no versioning exists.

File_Share2

If we view the file in Storage Metrics, it’s been inflated to a whopping 13.5MB – almost ten times the original size!

Storage_Metrics2

Just for validation, the version history is recorded and confirms a single version of the file at 1.4MB.

Versions1

Testing

To test what is happening, I have created a word document 576KB and have copied this to another account in the same tenant using the following methods;

  • Copied with SharePoint Migration Tool
  • Uploaded from the interface
  • Dragged from desktop to browser

With each method, the result is the same, OneDrive for Business shows the file as 576KB as expected.

All_Files1

Looking at the storage metrics for the same files paints and different picture.

All_FilesStorage1

Initially, the files when uploaded appear to be the correct size, however if left, the total size does then inflate to 23.8MB approximately 43 times the original size.

All_FilesStorage2

Subsequently, this was tried with more files in OneDrive for Business and SharePoint sites in other tenants in various data regions. There was no difference observed in behaviour for any of the testing carried out.  We did confirm however that there is no relationship between the expected file size and the inflated size being reported.  It was also noted that this appeared to affect but was not limited to docx, pptx and pdf files.

Conclusion

An outstanding call is currently with Microsoft to explain the behaviour of this as they have recently stated that this is by design and caused by meta and additional data being stored for previews.

However, as storage metrics appear to be the mechanism for calculating remaining storage space for observing quotas, this means that when migrating or uploading data to OneDrive for Business or SharePoint Online it’s practically impossible to calculate how much storage space is required.  Taking the example given above, it’s entirely feasible that 1GB of storage could be required to store just 25MB of documents.

Updates

01/03/2018 – After further testing with a tenant on the “Standard release” channel in the UK data region, the file sizes appeared to remain normal.  After switching my lab tenant to “Targeted release for everyone” the files inflated after being viewed.  This time, one of the same files was considerably larger, 83 times larger.

Capture

28/03/2018 – Microsoft have confirmed that this is normal and have updated me with the following statement.
This is an expected behaviour for files that service reported size to be larger than on device size as the service size includes additional size for metadata, versions, file preview images in addition to stream size (whereas device size only includes stream size).

To meet this particular clients quota needs, it was suggested that the preview functionality was turned off for the tenant. Removing this functionality as a means to address the issue was obviously not a valid approach.  With OneDrive for Business having unlimited storage, this doesn’t really present a problem if quotas aren’t being configured.  However, I have additionally asked for a statement on how storage metrics are used, if at all when calculating the requirement for additional space in SharePoint Online.   Do these inflated sizes count towards the 1TB per tenant and 0.5GB limit per user?  If I buy additional storage, am I getting what I paid for?

13/08/2018 – Interestingly, Microsoft raised the storage allowance to 10GB from the existing 0.5GB per user back in July as described in “SharePoint Online Limits“. However, the storage metrics issue is still ongoing.  Microsoft confirmed to me back in July that “we started deploying this fix now first for internal farms and will monitor results on our end. If all goes as expected we should see these changes in the upcoming days in production farms.

The latest communication today states that for “the moment we’re still monitoring and validating the results for the internal farms on our end.“.  I’ll update back here when I get further news on the results.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s