Video Screencast Help

How to report your Archive Rate

Created: 03 Mar 2009 • Updated: 23 May 2010 | 4 comments
Glenn Martin's picture

I just wanted to post this up since I know this comes up in discussion from time to time and also because I need to reference this "How to" in an upcoming survey we've got planned, looking at EV & Virtualisation.

So I realise you can of course use EV Reports if you've got it installed to see what your daily archive rates are but here's a SQL query that you can use on an adhoc basis to report against your vaultstore(s) and show how many items have been archived over a number of hours or between specific dates.

This article assumes you've got enough knowledge to run an SQL query but in essence you just need to post the following text into a new SQL Query window and change the "use" statement to use the relevent vaultstore database and adjust the dates to suit your requirement.

The query will then dump out a report and show you the number of items & size of the data archive for each hour durring the time period you've choosen - hopefully some of you will find this of use.

-- *********************************************************************
-- This query allows you to report from SQL to show the
-- archive rates for which ever Vault Store is of interest
-- It reports on an hour by hour basis
-- You just need to decide if you want to look for the last xx hours
-- or if you want to analyze a specific date range
-- *********************************************************************

-- *** Change the following line to select the relevant DB
Use [NameOfYourVaultStoreDB]

select "Archived Date" = left (convert (varchar, archiveddate,20),14),
"Hourly Rate" = count (*),
"Av Size" = sum (itemsize)/count (*),
"Hourly KBs" = sum (itemsize)
from saveset

--  **
--  ** Decide which criteria you need to report
--  ** Either the last 3 days or the specific date range
--  **
-- This one to get last 3 days
-- where archiveddate >dateadd("hh", -72, getdate ())

-- This one uses a date range
where archiveddate>'2009-3-1 07:00' and archiveddate<'2009-3-2 19:00'
group by left (convert (varchar, archiveddate,20),14)
order by "Archived Date" desc

Comments 4 CommentsJump to latest comment

Judy Glazier's picture

We just configured EV8.0 on vmware esx 3.5

We noticed that manual archiving and the journaling are working extremely slow.  There are no errors in the Symantec Enterprise Vault event log, but it still is unrealistically slow.

I know that virtualization is slower than a stand-alone pc running EV but documentation shows instead of a approximately 25,000 items per hour on stand-alone server, vmware gets approximately 18,000 items per hour.  But this is more like it taking 10 minutes to archive 4 items in the journal mailbox.

Has anyone else seen this type of response from a Vault server configured on a virtual server?

the page file has been moved off the system drive and the Windows temp file as well.

Judy Glazier

Judy Glazier's picture

Sorry Glen I am still trying to figure out how to post on this new forum.

Michael Bilsborough's picture


This is more accurate (since it reports on the original date size as well as the EV size)

select "Archived Date" = cast (archiveddate as smalldatetime),
"Minute Rate" = count (*),
"KB (original)" = sum (originalsize)/1024,
"KB (compressed)" = sum (itemsize)
from saveset, savesetproperty
saveset.savesetidentity = savesetproperty.savesetidentity
-- and archiveddate > dateadd("hh", -24, getdate ())
group by
cast (archiveddate as smalldatetime)
order by
"Archived Date"

Liam Finn's picture

All of this info is available if you install the EV reporting services. These canned reports are available through Reporting Services. You can even schedule them so they will email the report to you on a schedule you specify