ビデオヘルプ

Average collection count for EV with centera

作成: 03 Oct 2012 • 更新: 04 Oct 2012 | コメント数: 3
Fremont の写真
この問題は解決されました。 ソリューションを参照してください。

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,

タグでディスカッションを検索:

コメント コメント数: 3最新のコメントを表示

TonySterling の写真

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

ソリューション
Fremont の写真

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

Thanks,

TonySterling の写真

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