Average collection count for EV with centera
Created: 03 Oct 2012 | Updated: 04 Oct 2012 | 3 comments
This issue has been solved. See solution.
Hi,
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.
Thanks,
Discussion Filed Under:
Comments 3 Comments • Jump to latest comment
I modified a query for sparse collections found here: Article URL http://www.symantec.com/docs/TECH87400
this should give you want you want:
SELECT TOP 1000
a.PartitionName as 'Partition',
b.RelativeFileName AS 'Collection',
b.RefCount AS 'Current No of Items in Cab'
FROM
EnterpriseVaultDirectory.dbo.partitionentry a,
<VSDBNAME>.dbo.collection b
--Replace <VSDBNAME> with the SQL DB Name - For example EVVaultStore1
Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK
Very interesting. This is giving us the numer of items in each cab file for the last 1000. Nice. This will do.
Thanks,
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.
Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK
Would you like to reply?
Login or Register to post your comment.