Setting the Minimum BLOB Storage Size Correctly

119

How to set the Minimum BLOB Storage Size

Setting the minimum storage size for BLOBs is a bit tricky.  It turns out that setting the property generally does not work, and the SPRemoteBlobStorageSettings object does not have an associated update() method.  Trying to update the container object (Content DB) doesn’t work either.  The trick is to use the associated method to set the value:

$rbs.set_MinimumBlobStorageSize(number)

Here’s a script that iterates through a set of content DBs, and sets the min blob size.  I prefer to work with lists of DBs:

$DBList="Content_1,Content_12,Content_3"
$DBs=$DBList.split(",")
for ($i=0; $i -lt $DBs.count; $i++)
{
# Provide your content DB name using the name of the Content DB, or if there's only one Content DB for a web app, you can get it by identifying the web app
$cdb=Get-SPContentDatabase -identity $DBs[$i]

$rbs = $cdb.RemoteBlobStorageSettings

#here's what not to do. This does not work; min blob size is lost; save conflict
#$rbs.MinimumBlobStorageSize =25kb # this is the minimum size of a file to be sent to the Blob Store; anything smaller is kept in the Content DB.

#a much better approach is to use the method to set the value, this does not require an update() method. Note the SPRemoteBlobStorageSettings ($rbs here is that type) does not have an associated update() method
$rbs.set_MinimumBlobStorageSize(25*1024)
}

Here’s a script to ensure that RBS is configured correctly, and the min blob size is what you expect it to be:

$DBList="Content_1,Content_12,Content_3"
$DBs=$DBList.split(",")</pre>
for ($i=0; $i -lt $DBs.count; $i++)
{
$cdb=Get-SPContentDatabase -identity $DBs[$i]
$rbs = $cdb.RemoteBlobStorageSettings

write-host "RBS installation for $($cdb.name) is $($rbs.Installed())"

write-host "MinBlobStorageSize for $($cdb.Name) is $($rbs.MinimumBlobStorageSize)"
}
<pre>

Share this entry

One Response

  1. It’s recommended to move BLOBs outside of SQL Server since they can really weigh down SharePoint content databases. This results in slow search and file upload and download speeds.

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents

Categories

Categories