We are using SQL Server 2014 and SharePoint 2013
closed as unclear what you're asking by Gaurravs, Asad Refai, P S, Karthik Jaganathan, Robert Lindgren Feb 15 at 14:53
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
You can modify the minimum BLOB storage size for each content database from the default size of 5 MB:
Start the SharePoint Management Shell. At the Windows PowerShell command prompt, type the following commands to modify the minimum BLOB storage size to 1MB.
$cdb=get-SPContentDatabase ContentDatabaseName $cdb.RemoteBlobStorageSettings.MinimumBlobStorageSize=1048576 $cdb.Update() iisreset -noforce
Reference: Modifying the Minimum BLOB Storage Size
You also need to have a look at Shredded Storage Chunk Size (also known as FileWriteChunkSize). The FileWriteChunkSize must always be greater than MinimumBlobStorageSize. If this rule is broken, no content will get externalized!
FileWriteChunkSize gets configured at WebApplication level (example: 2MB):
$webapp = Get-SPWebApplication http://yourwebappurl $webapp.WebService.FileWriteChunkSize = 2097152 $webapp.webservice.Update()