views:

1266

answers:

5

I have a list with roughly 5500 items, and I would like to find out the size on disk. Is there some way I can do this? I don't mind running a query in the database, if necessary.

+1  A: 

If you save the list in question as a template to the file system, this should give you a rough idea of its size. If you need to do this on a periodic basis this approach is not as useful.

Jason Weber
+3  A: 

Navigate to http://[myapplication]/[mySitecollection]/_layouts/storman.aspx

This will list the Storage Space Allocation for the site collection.

Nat
+4  A: 

If you enable a site quota, an option under site settings appears called Storage Space Allocation. When you go to set a quota in the Central Administration, the page will tell you what the current storage used is so you can have an idea before there. Once you get to the Storage Space Allocation report, you can see the total size of a library.

Unfortunately, you can't get this report without turning on a site quota.

ICodeForCoffee
p.s. site quotas are a really good thing - it is amazing how fast unfettered users can upload documents.
Nat
+1  A: 

We actually built an inhouse application to do this, but there may be some commercial products out there.

Anyway what we do is go through each item in the list and count up the number of bytes for each field. If there is a document we add in the size of this document. If there are versions then we multiple the byte count for each version. Then we multiple this times 1.5. Not exact, but it provides us with a number that is good enough.

JD
How do you count up the number of bytes per field?
Linda