For several document libraries in our SharePoint environment end user enabled versions without setting a limit. Or were given a document library with unlimited versions(result of having no governance in the past) Now we want to limit the number of versions being used. Thus we set the limit for one document library to 10 (as a test).
Once this setting is in place and an user edits some metadata on a document with ~300 versions (a 5MB document) the whole environment grinds to a halt, making it unavailable for 10 minutes and the new metadata values are not saved for that document.
ULS log gives no hints, Eventlog records an AppPool recycle, CPU load is low (SharPoint and SQL)
What is going on here? And how do I 'gently' get rid of the superfluous versions? (Now we have serveral document that take an awfull lot of DB space: a 6MB document with 300 versions takes 1.8 GB of database space!)