Rough idea of upgrade time from 8.5 to 9

Question

Hi there,

I am scheduling my Orion upgrade from version 8.5 to version 9.  The database is about 100GB in size.

In rough terms - how long should I expect the  database upgrade portion to take?  (I know it will also depend on the systems, bandwidth, etc - just looking for an idea.)

Other than the database, any best practices of items I should backup before starting?  (we have Orion SLX plus the additional web server and additional polling station)

thanks

njoylif · Answer

Not sure if they fixed this piece or not, but I had to drop all of the custom poller tables before my implementation would go forward.

OswegoSam · Answer

Completed my upgrade - and it certainly took more than an hour.  I learned something very important!  Before starting an upgrade make sure you have lots of free space on the SQL server as it (apparently) build a new table and copy the data into the new format.  Our database grew even larger and actually totally used up the disk space.

Luckily we were able to recover by purging all of the netflow data (which we should have done first as we didn't care too much about the historical data) and shrink the database.  Once that was done it only took somewhere around 15 minutes or less to do the DB portion.

For anyone really interested, all in all to upgrade every component, plus deal with the failed DB, it took about 6 hours from start to finish.  It probably would have taken half that time if I had purged and run a shrink before I started.

FormerMember · Answer

If you download from your portal now, SP2 is included automatically.