11-12-2015 09:04 PM
Hi
We have an especially large Enterprise Vault installation, been running for 3 years as it is now. (currently 10.0.4).
Apart from physical limitations of running out of disk, are there any limits that we might see, for example SQL rows, or maximum number of items indexed/archived etc..
i.e. will EV just stop working one day, or will it keep growing? (as long as we chuck disk at it)
Cheers
Solved! Go to Solution.
11-12-2015 10:46 PM
Reasonably large :)
As for the Vault Store items in a database, I believe the value 350.000.000 should be a parameter to create another store.
One thing to keep in mind is to make sure your maintenance on SQL is being performed regularly.
Keeping the databases healthy will assist in performance.
Are you by any chance doing deletions (archives and/or Storage Expiry)? If so, you also migh want to as Michel states, do some distributing between stores, to keep the balance more or less equal.
It also depends on what underlying storage you have etc, but if it runs good, there should not be a reason for it to 'suddenly' stop. You might want to check with Veritas on their recommendations to be sure.
Greetz,
GJ
11-12-2015 09:25 PM
If there is any limitation from SQL side w.r.t to number or items , tables row. etc, so this will limit EV. EV as such is scalable enough .
Refer . It supplements Microsoft best practice advice for sizing, tuning, and maintaining SQL Servers.
11-12-2015 09:26 PM
Hi
Please define "especially large", what is large for some is just tiny for others :)
EV will happily keep growing. What you should try to do is distribute the load to multiple Vault Stores, I think the recommendation is still to have <100 mio Items per Vault Store.
Apart from that, if you can keep up with CPU/Memory/Disk, EV should definitely not "stop working"
Cheers
11-12-2015 09:32 PM
Hi
We have 6 Exchange Mailbox Archiving servers 140,000 mailboxes being archived, around 995 Million items archived, 278 Terrabytes of archives..
4 Journal archive server running 24x7 archiving around 1.5 million emails a day.
Cheers
11-12-2015 09:35 PM
OK, that does count as large :)
But yeah, if you take above comment into consideration, you should be fine.
11-12-2015 10:46 PM
Reasonably large :)
As for the Vault Store items in a database, I believe the value 350.000.000 should be a parameter to create another store.
One thing to keep in mind is to make sure your maintenance on SQL is being performed regularly.
Keeping the databases healthy will assist in performance.
Are you by any chance doing deletions (archives and/or Storage Expiry)? If so, you also migh want to as Michel states, do some distributing between stores, to keep the balance more or less equal.
It also depends on what underlying storage you have etc, but if it runs good, there should not be a reason for it to 'suddenly' stop. You might want to check with Veritas on their recommendations to be sure.
Greetz,
GJ
11-15-2015 01:51 PM
GertjanA - Yes we have 7 Vault Stores each with 5 partitions, on each server, and no, we don't do any deletions at all. SQL Maintenance is run methodically every night, and we are well within the 350M per store, we have Tier 1A FC SAN so it's all nice and quick.
Sounds like we should be ok for a while then, thanks for your input everyone :)
11-15-2015 04:20 PM
Lee, what are you doing in terms of backups?
11-15-2015 04:26 PM
Hi Andrew,
We do daily full backups of open partitions (partitions are a maximum of 500GB) - once closed, we do a final backup, and then never back it up again.
11-15-2015 05:10 PM
What about collections (aka CAB files.) Do you have collections turned on?
Also, you must have an insaine amount of Indexes for such a large archive. How are you backing them up?
11-15-2015 05:28 PM
Yep, we do collections... 25MB collections, older than 30 days... indexes are just backed up daily full too...
We have the standard 8 indexes per server... and they take maybe 4 hours a night to do a full back up (all 8 indexes per server)
11-16-2015 10:28 AM
thank you