SharePoint 2010 How much space does a user actually have?

Hi Fbyrne,

Per my knowledge, there is overhead in SharePoint content database, such as metadata for the files uploaded to SharePoint.

And the size of the overhead in your database is depends on the content in your site.

If a user upload a document to SharePoint, SQL needs to keep auxiliary structures such as transactions logs, indexes, document properties in order to store the document.

So if the overhead is too big, you can clean up the space by the SQL database defragmentation and shrink operations.

More references:

http://ift.tt/1E4yNiJ

http://ift.tt/1FXW4Vv

http://ift.tt/1E4yODj

Best regards.

Thanks

---

Victoria Xia

TechNet Community Support