Any way to determine the amount of space versioning is taking up ina Sharepoint site collection for MOSS 2007?

Hi, There is no good way to get the exact spaces what the versions have taken. I found a method which can evaluate the database size about versions for SharePoint 2010, you can check this: http://technet.microsoft.com/en-us/library/cc298801.aspx#sectoin1b it might be helpful for you. Thanks! StanffordEverything will be fine.

I have written an app that can show you this. It displays the disk space used by SharePoint. To answer your post, it can show you the total size of all documents as well as the size of the versions. http://www.thesug.org/Blogs/lsuslinky/SSM Tim

thanks I actuaually downloaded this a while ago and never used it. Does it work on a site collection level?

did you get your answer?Everything will be fine.

Not yet, the tool mentioned above isnt working for this particular site collection. I have ran the query above and get the numbers for the Versions table but I cant determine how that relates to the actual size. I realy am just look to estimate if versioning is an "issue" or not

Does each version take up the same amount of space? Do 5 versions of a 4mb doc take up 20GB?

Hi, Sharepoint stores a complete copy of each version of your document in the database. It means that 5 versions of a 4 mb document takes 20 mb. Also, you should multiply the size of initial content by 1.3 for the size of stored content in a SQL database. Please have a look at this article for more information : http://technet.microsoft.com/en-us/library/cc261795(office.12).aspx Hope it helps you, MarioMon Blog/My Blog (in french) LinkedIn

is there a way based of the tables to determine what % of total docuement size versioning takes up

Hi, I'm not aware of a way or a tool to obtain or calculate the size of all the documents/version in content database. I'm sure that you should be able to do it with code. It's not supported to query directly the database. You must use the object model to do it. Directly querying the database can place extra load on a server and hence performance issues. Direct SELECT statements against the database take shared read locks at the default transaction level so your custom queries might cause deadlocks and hence stability issues. Please have a look at this article for more information : http://support.microsoft.com/kb/841057/en-us However, if you still want to do it, at your own risk, you could read this thread from stackoverflow: http://stackoverflow.com/questions/213801/sharepoint-2007-sql-query-to-find-a-list-of-documents-in-site-collection. You will find information about a query that you will have to modify to meet your specific need. But at least, you will have something to start with. Hope it helps you, MarioMon Blog/My Blog (in french) LinkedIn

Yes. It has a switch to either look at the current site or all sites below the current. Choosing the root site and looking at all sites below will return the value for the site collection.

Still unable to get it to work, I get errors everytime I run the tool.

email me at sharepointspacemonitor AT gmail DOT com and I'll work with you to figure out why you're getting errors. Tim