Calculating Size of Site Collection, Sub Sites in Multiple Ways

Jean Paul

SharePointSub SitesServer Object Model using C#Size of Site CollectionSTSADM Command

13 Comments

Join the conversation! Your thoughts help the community grow.

Илья Свергин10y ago
For anyone, who has the same problem as Gangadhar. You need to move two functions - GetFolderSize and FormatBytes in the begining of the script (e.g. after variables). I had the same problem and this helped me.
Sr Karthiga10y ago
Good one
Gangadhar m11y ago
Hi Paul,Am executed above Powershell script to determine size for sites within the site collection in SharePoint 2007 but am not able to getting size it only showing/displaying sites and subsites names with in the site collection but not the size. while executing the script initialy few errors are encountered. please suggest me. thanks. Gangadhar.M
srikanth srikanth12y ago
I am implementing Solution2 in custom webpart, it is taking more time to complete Foldersize loop. Let me know any thing i need to consider for Sever object model.
Jean Paul14y ago
Thank You Vijay for the good words!
Vijay Prativadi14y ago
Superbbb...! This is called Awesome!
Jean Paul14y ago
Thank You Chandan, Mahesh, Neha, Veena, Dipali for the good words.. I had one more point to add here. (sorry for delay) In one of the client installations with 5 Terra Bytes of site collection items, the above c#/powershell code were sluggish as it looped through each items, versions etc. (took more than 3 hours and crashed) Following is the code which worked quickly, but it is a deprecated way (took only few seconds) siteCollection.StorageManagementInformation( SPSite.StorageManagementInformationType.DocumentLibrary, SPSite.StorageManagementSortOrder.Decreasing, SPSite.StorageManagementSortedOn.Size, 1000000 ) I will be adding an article on the same.
chandan kumar14y ago
Nice article..
Mahesh Chand14y ago
As Veena said, Interesting. I never thought of getting size this way. In one of my SharePoint projects, I needed the size and I used regular Directory and File classes in ASP.NET WebPart.
Neha Sharma14y ago
Good One.
Veena Sarda14y ago
Interesting post.
dipali goel14y ago
Really such a knowledgeable article.I 'll try this definitely.
Lakshya Arora14y ago
Thanks for sharing this wonderful article.

Calculating the size of a Site Collection or Sub Sites is a periodic task in the lifetime of a SharePoint Deployment. The calculation is required in the following scenarios:

Determining the Site Collection usage & progress for Reporting purposes
Finalizing Architectural Decisions on Expansions or Splitting of Site Collections
Periodical Analysis of Site Quota & Usage

Note:

The term refers to the size occupied by the entity. Please note that the Total Size calculated might be less than the Content Database Storage Size as there is surplus space allocated.

Solutions

The following are the solutions to calculate the size.

Solution 1: STSADM Command

STSADM contains a command to return the Size of a Site Collection, as in:

stsadm -o enumsites -url http://Server

This command should return the number of Sites & the size for the URL specified, as in:

<Sites Count="2">

</Sites>

Note:

STSADM is deprecated and the preceding operation does not yield Drill Down results. We can continue our exploration of other possibilities.

Solution 2: Server Object Model using C#

Using the Server Object Model we can write a Console Application to display more drilled down information like the size of Site and Sub Sites. Here we are including the following entities:

Site
Sub Sites
Folders
Files
File Versions
Recycle Bin

Code

The following is the code which performs the above activities, formats the size and outputs the result on the console:

static void Main(string[] args)

{

long siteCollectionSize = 0;

string baseUrl = "http://hp";

Console.WriteLine("Base Url: " + baseUrl + " (Change baseUrl to list sites starting with)");

using (SPSite mainSite = new SPSite(baseUrl))

{

foreach (SPWeb web in mainSite.AllWebs)

{

long webSize = GetSPFolderSize(web.RootFolder) + web.RecycleBin.Cast<SPRecycleBinItem>().Sum(r => r.Size);

if (web.Url.StartsWith(baseUrl))

{

Console.WriteLine(string.Format("({0} {1}", web.Url, FormatSize(webSize)));

siteCollectionSize += webSize;

}

Console.WriteLine("Total Size: " + FormatSize(siteCollectionSize));

Console.ReadKey(false);

}

public static long GetSPFolderSize(SPFolder folder)

{

long folderSize = 0;

foreach (SPFile file in folder.Files)

folderSize += file.TotalLength

+ file.Versions.Cast<SPFileVersion>().Sum(f => f.Size);

folderSize += folder.SubFolders.Cast<SPFolder>().Sum(sf => GetSPFolderSize(sf));

return folderSize;

}

public static string FormatSize(long size)

{

if (size > Math.Pow(1024, 3))

return (size / Math.Pow(1024, 3)).ToString("#,#.##") + " GB";

else if (size > Math.Pow(1024, 2))

return (size / Math.Pow(1024, 2)).ToString("#,#.##") + " MB";

else if (size > 1024)

return (size / 1024).ToString("#,#.##") + " KB";

else

return size.ToString("#,#.##") + " Bytes";

}

On executing the code above, you will get the following results:

Output-Size-of-Site-Collection-Sub-Sites-in-multiple-Ways.jpg

You can change the baseUrl to list only the sites starting with a value.

Solution 3: Using PowerShell

The following is the PowerShell script which performs the same functionality of C# code. As always PowerShell provides lightweight solutions without deployment & modification hassles for the IT Professionals.

The following is the PowerShell script which performs the same functionality.

# Returns size of site, subsites, folders, outputs in .\SiteSize.html

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")

$rootUrl = "http://hp/wiki";

$rootSite = new-object Microsoft.SharePoint.SPSite($rootUrl);

$array = @()

$siteCollectionSize = 0;

foreach($web in $rootSite.AllWebs)

{

if ($web.Url.StartsWith($rootUrl))

{

$websize = GetFolderSize $web.RootFolder;

foreach($recycleBinItem in $web.RecycleBin)

{

$websize += $recycleBinItem.Size;

}

$formatSize = FormatBytes $websize;

$url = $web.Url;

# Create object and store in array

$obj = New-Object System.Object

$obj | Add-Member -type NoteProperty -name "Description" -value "$url"

$obj | Add-Member -type NoteProperty -name "Size" -value "$formatSize"

$array += $obj

$siteCollectionSize += $websize

}

$formatSize = FormatBytes $siteCollectionSize;

# Create object and store in array

$obj = New-Object System.Object

$obj | Add-Member -type NoteProperty -name "Description" -value "[Total Size]"

$obj | Add-Member -type NoteProperty -name "Size" -value "[$formatSize]"

$array += $obj

# Display

foreach($item in $array)

{

write-output $item

}

# Write to HTML

$array | Select-Object | ConvertTo-Html -title "Site Size" | Set-Content .\SiteSize.html

# Function calculating folder size

Function GetFolderSize($folder)

{

$filesize = 0;

foreach ($file in $folder.Files)

{

$filesize += $file.TotalLength;

foreach ($fileVersion in $file.Versions)

{

$filesize += $fileVersion.Size;

}

foreach ($subfolder in $folder.SubFolders)

{

$filesize += GetFolderSize $subfolder

}

return $filesize;

}

# Function to format in MB

function FormatBytes ($bytes)

{

switch ($bytes)

{

{$bytes -ge 1TB} {"{0:n$sigDigits}" -f ($bytes/1TB) + " TB" ; break}

{$bytes -ge 1GB} {"{0:n$sigDigits}" -f ($bytes/1GB) + " GB" ; break}

{$bytes -ge 1MB} {"{0:n$sigDigits}" -f ($bytes/1MB) + " MB" ; break}

{$bytes -ge 1KB} {"{0:n$sigDigits}" -f ($bytes/1KB) + " KB" ; break}

Default { "{0:n$sigDigits}" -f $bytes + " Bytes" }

}

}

Solution 4: Advanced Tools

There are many tools available in CodePlex to calculate the size of SharePoint sites. I would like to list one of the best tools for this purpose.

The tool is named SharePoint Space Monitor and you can download it from:

http://scmodsoft.com/download/

You need to register with an email id to get the registration code. On executing the tool you will see the following screen with graphical charts and drill down options.

solution-Size-of-Site-Collection-Sub-Sites-in-multiple-Ways.jpg

References

http://tinyurl.com/sp2010-stusg

Summary

In this article we have explored the Site Collection Size calculation options and tools associated. I hope the information should be useful in real-world scenarios.