Vault Store DB unusually big.

[The_Boulon]

Hello,

My customer archived like 17 millions files some days ago.

When looking at the VS DB, it looks unusually big, like 58,3Gb!

Is this a normal behaviour?

Thx

Olivier

[JesusWept3]

Take a look at this query here and run it against the vault store table
It will tell you which table is taking up the most space, and it could possibly be an index

http://therightstuff.de/CommentView,guid,df930155-f60f-4f56-ab33-f1352ff091a1.aspx

But really it could be a couple of things like you could be looking at the translogs and db combined
or more likely than not, someone set the AutoGrowth too hight
 

[The_Boulon]

Indeed the SavesetProperty is taking a lot of place.

name                  rows        reserved           data               index_size         unused

SavesetProperty   18008136    40354736 KB        35717640 KB        4632080 KB         5016 KB

Any idea why?

[Rob_Wilcox1 · Accepted solution]

And the 'answer' would appear to be at least related to:

http://www.symantec.com/connect/ideas/change-itemid-and-properties-fields-data-types-reduce-savesetp...

[JesusWept3]

Are you doing a lot of FSA perchance?
I checked on a DB that i have with 42 million rows (so over twice as many as yours
But uses 1.5GB data as opposed to your 35GB and 730MB indexes as opposed to your 4.6GB

And based on the post rob linked to, it would most likely be coming from these Properties columns