Determine amount of space that versioning is taking?
Any way to determine the amount of space versioning is taking up ina Sharepoint site collection for MOSS 2007?
October 26th, 2010 9:50am
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.
October 29th, 2010 1:53am
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
October 29th, 2010 9:41am
thanks I actuaually downloaded this a while ago and never used it. Does it work on a site collection level?
October 29th, 2010 10:24am
did you get your answer?Everything will be fine.
November 3rd, 2010 3:17am
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
November 3rd, 2010 9:09am
Does each version take up the same amount of space? Do 5 versions of a 4mb doc take up 20GB?
November 3rd, 2010 11:22am
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
November 3rd, 2010 1:24pm
is there a way based of the tables to determine what % of total docuement size versioning takes up
November 3rd, 2010 1:30pm
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
November 3rd, 2010 2:23pm
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.
November 4th, 2010 8:48am
Still unable to get it to work, I get errors everytime I run the tool.
November 4th, 2010 8:59am
email me at sharepointspacemonitor AT gmail DOT com and I'll work with you to figure out why you're getting errors. Tim
November 5th, 2010 9:23am