Hi all,
Today I am trying to work on selecting the number of savesets in a Vault store database grouped by year.
Has anyone done this before or have any pointers on it?
Thanks,
Jeremy.
Hi all,
I know there are many factors involved in storage expry, in our environment the expiry rate is anything up to 1500 items per hour.
Can anyone weigh in with what expiry rates per hour you are seeing?
Thanks,
Jeremy.
In an EV 9.0.4 deployment the storage expiry task does not obey the schedule once it is running. Since it was not consistently turned on it can run for days without stopping and writing 7085 reports in the event log. A report is created if the storag...
Does the same query for those on legal hold look like this?
select year(s.ArchivedDate) as 'year',
COUNT(s.SavesetIdentity)
from saveset s
where s.SavesetIdentity in (select SavesetIdentity from HoldSaveset where holdsaveset.savesetident...
Hey guys,
Yeah it has been a little while. I have moved jobs and countries. Now in the US.
I completely agree the performance is slow and SQL is more than likely the bottleneck. I am onto my DBAs asking them to monitor the DB server (thankfully ded...
Thanks. I have been speaking with my DBA and it looks like SQL maintainence has been suspended for a long time. I now have a list of things to work on with this EV system which need attention.
Thanks all.
