Estimate time for EV upgrade from 8 to 9 ? JournalArchiveTable of 90million

[juggernaut1]

Anyone experienced upgrades with large numbers in the journalarchive table?  Looking for an estimate of downtime as there are multiple servers involved.

Thanks,

DB Name                                             Data File Size (MB)          Log File Size(MB)              Total size(MB)

EnterpriseVaultDirectory              1210                                       5300                                       6510

EnterpriseVaultFSAReporting     4100                                       35980                                    40080

EnterpriseVaultMonitoring          170                                         3100                                       3270

EVConfiguration                               10                                           36                                           46

EVDiscovery                                       30000                                    15489                                    45489

EVFSAVaultStore                             15600                                    4400                                       20000

EVMailVaultStore                            144400                                19000                                    163400

EVFSAVaultStore

JournalArchive -               2049818

SaveSet -                             6373928

EVMailVaultStore

JournalArchive -               91439763

SaveSet -                             209482334

EVSharePointVaultStore

JournalArchive -               2290

SaveSet -                             191021

EVMailVaultStore2

JournalArchive -               0

SaveSet -                             0

EVMailVaultStore2                          100                                         100                                         200

EVSharePointVaultStore               400                                         201                                         601

[JesusWept3 · Accepted solution]

how many items are in the journal archive table?
its really like how long is a piece of string, it all depends on how many items, the sql server itself, whether its shared, what kind of disks are in use, memory, processor etc

and its not really a matter of how much is in the journal archive, but how much is awaiting backup and the number items in your watchfile

Honestly, i wouldn't expect it to take that long at all

[WiTSend]

I just finished an upgrade from 9 - 10 (13 servers) in an environment of 20k+ users for 5 years.  The entire process took about 1 hour per server.  The longer portion was data migration.  If you are doing an inplace upgrade you should expect less than 1 hour per server.

[JesusWept3]

The upgrade that i did from EV8 to to EV9 with tens of thousands users on each site, was about 20 mins per server from start to finish of starting the setup, restarting the server and running the directory and storage and having them upgrade

[juggernaut1]

upgrading sharepoint agents should only take a few minutes?  will there be a reboot?

[juggernaut1]

upgrade of storage db  is going on over 9 hours now..  

[juggernaut1]

--Populate
update JournalArchive
set journalarchive.SavesetIdentity = Saveset.SavesetIdentity
from JournalArchive inner join Saveset on Saveset.IdTransaction = JournalArchive.TransactionID
where JournalArchive.SavesetIdentity IS NULL

this has been running for a long time..