Video Screencast Help

Average collection count for EV with centera

Created: 03 Oct 2012 • Updated: 04 Oct 2012 | 3 comments
Fremont's picture
This issue has been solved. See solution.


We are using EV10.0 journaling on centera with collections enabled.  Does anyone know if there is a way to get the average number of items ev is collecting before sending to centera?  Performance guide mentions 100 items or 10MB.  Wondering if EV saves collection info somewhere in sql where we can query.


Comments 3 CommentsJump to latest comment

TonySterling's picture

I modified a query for sparse collections found here: Article URL

this should give you want you want:

a.PartitionName as 'Partition',
b.RelativeFileName AS 'Collection',
b.RefCount AS 'Current No of Items in Cab'
EnterpriseVaultDirectory.dbo.partitionentry a,
<VSDBNAME>.dbo.collection b

--Replace <VSDBNAME> with the SQL DB Name - For example EVVaultStore1

Fremont's picture

Very interesting.  This is giving us the numer of items in each cab file for the last 1000.  Nice.  This will do.


TonySterling's picture

Yeah, I capped it a 1000 but you can change that pretty easily.  Wasn't sure the amount of data you were dealing with so wanted to control the volume returned.  wink