Advertisements

How much storage space is my site collection using?


NOTE: This post is just covering SharePoint 2010, and not earlier versions of the product.

imageA common question administrators have in their SharePoint environment is “How much storage space is my site collection using?”

Well, fear not, trusty SharePoint administrators! There are a few ways to skin this cat – and we’re going to take a look at them.

 

SharePoint Designer

SharePoint Designer – what was once something administrators and power users shuddered at the mere mention of the tool in prior versions of the product, has gotten a makeover. And, also has a lot of additional functionality. For today’s lesson however, we are only going to look at one specific feature of it – the ability to view the storage used for an entire site collection!

If you open up SharePoint Designer to the root site of your site collection, in the main window, once the site is opened under Site Information, you will see, as highlighted below, that it will conveniently display the Total Storage Used of your entire site collection! There! As the big red button on my desk often says after a good firm press… “That was easy!”.

image

Let’s look at a couple of other methods of getting this information, shall we?

StorMan.aspx – SharePoint 2010 Service Pack 1+

This one requires Service Pack 1 to be installed to be able to utilize this feature. It was not in the RTM version. At the root of your site collection, if you go to Site Actions > Site Settings > Site Collection Administration > Storage Metrics, this will give you details on the usage – such as what sites, lists, libraries, and items are taking up the most space, however, it will not give you a total like our trusty SharePoint Swiss Army Knife – SharePoint Designer does, but, it will allow you to drill down into the usage.

image

I will also urge you to view Bill Baer’s article on Storage Metrics in Service Pack 1 – which has some great screenshots of the functionality, as well as an overview, available here: http://blogs.technet.com/b/wbaer/archive/2011/06/28/service-pack-1-storage-metrics-storman-aspx.aspx

PowerShell

imagePowerShell, one of the other power tools in SharePoint 2010, much more akin to the Ginsu knife, can also serve up the details, and, like the Ginsu knife, allow you to slice and dice the information in a myriad of ways.

Below is an example script to connect to your site collection, and read out all of the usage information.

$site = Get-SPSite http://my.sitecollection.com
$site.Usage;
$site.Dispose();

Which gives the following output (storage shown highlighted below in bytes):

image

To view just the Storage property, and not Bandwidth, Visits, Hits, and DiscussionStorage, you can call this:

$site = Get-SPSite http://my.sitecollection.com
$site.Usage.Storage;
$site.Dispose();

And only the Storage property with the total bytes will be displayed. You can also do some other cool tricks, such as calculating kilobytes, megabytes, gigabytes and terabytes right from the command line as well, to make the results a bit more readable:

image

Want more? OK! We can give it to you! Keep reading! (Because, reading is fundamental, you know.)

Web Analytics

Another option to view the storage used, as well as some additional metrics around it, if you have Web Analytics enabled, you can view your usage over time. To see this, go to Site Actions > Site Settings > Site Actions > Site Collection Web Analytics reports

image

Once there, in the main screen, you can view a summary of the Total Storage Used under Inventory.

image

And if you click on Storage Usage under Inventory within the quick launch navigation on the left, you can then view reports on storage utilization for your site collection, with a graph of the values so you cane easily visualize the trend in storage usage.

image

image

As well as a daily breakdown of the storage used, so you can see how this grows or falls over time.

image

You can also run reports for any date range since Web Analytics have been enabled, as well as run workflows against this data for alerting and reporting.

image

I hope you were able to learn something new today… have another method in which you get your site collection storage metrics? Leave it in the comments below for everyone else!

Advertisements

About Geoff Varosky
Geoff Varosky is a Senior Architect for BlueMetal Architects, based out of Watertown, MA. He has been architecting and developing web based applications his entire career, and has been working with SharePoint for the past 13 years. Geoff is an active member of the SharePoint community, Co-Founder and Co-Organizer of the Boston Area SharePoint Users Group, co-founder for the Boston Office 365 Users Group, co-organizer for SharePoint Saturday Boston and speaks regularly at SharePoint events and user groups.

6 Responses to How much storage space is my site collection using?

  1. Geoff- great post! Always love reading your stuff. Here is another option that lets you get quota information as well: http://www.sharepointlonghorn.com/Lists/Posts/Post.aspx?ID=39

  2. elwaha says:

    When I type in $Site.Usage I get NO results, however if I do just $Site it provides my https site from the Get-SPSite above, what am I missing.

  3. Kerem Ozen says:

    Reblogged this on Kerem Ozen's Blog.

  4. Pingback: SharePoint Daily

  5. Frank-Ove Kristiansen says:

    Hi,

    One thing that unfortunately ins’t included in these numbers, are the Audit logs. I noticed this a while back while studying the difference on the size between a single site collection in a content database and the actual database size.With Audit logging turned on in the site collection, the database size will always be bigger than what SharePoint reports in the various tools listed above.
    This was at least the case in SharePoint 2007.

  6. Pingback: My Sites Infrastructure Planning for SharePoint 2013 On-Premises Farm | SharePoint Interests

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: