Calculating Site Collection Usage via SQL

I have been slow on the informational posts lately, sorry about that! Have had lots happening in the work world over the past few months, and have not been able to get much done in that arena, between SharePoint Saturday Boston, The SharePoint Technology Conference, Best Practices Conference, business development, the SharePoint Saturday Boston Webinar Series, the Boston Area SharePoint Users Group, writing chapters for a book, as well as client work (last, but certainly not least), my blog entries have become few and far between.

I also need to get my feedburner redirected from live spaces, and oh so much more…

However, I thought I would write a quick post! I use this quick SQL statement from time to time, and used it again today, and wanted to share it quickly with the few souls that actually read this blog 🙂

   1: SELECT FullUrl AS URL,(DiskUsed/1024) AS SiteCollectionUsedKB from Sites


Simple, but, it gets the job done. From your content database, running this query will return the URL of the site collection, as well as its storage allocation. Handy, and useful!


About Geoff Varosky
Geoff Varosky is a Senior Architect for Insight, 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 15 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.

Leave a Reply

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

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

Facebook photo

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

Connecting to %s

%d bloggers like this: