nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Orion 8.1: Database can take a long time during upgrade

FormerMember

Database changes required to improve performance in this version cause the database update to take longer than in previous upgrades. For example, a database of 10GB can take over an hour to upgrade.

Find more posts tagged with

8.1_install

Accepted answers

All comments

Krezak6

Hi,

I'm a newbee. I have Solarwinds Engineers toolset and Cirrus. What is required to make Orion 8.1 work in a cisco environment? I am aware of Netflow, but have never had the need to implement it. Our company is basically to large campus's with about 700 employees. Any comments are appreciated,..thanks.

BryanBecker

Hi,
I'm a newbee. I have Solarwinds Engineers toolset and Cirrus. What is required to make Orion 8.1 work in a cisco environment? I am aware of Netflow, but have never had the need to implement it. Our company is basically to large campus's with about 700 employees. Any comments are appreciated,..thanks.

All you need is SNMP enabled on your devices and allow pings/snmp requests to those devices as well. Pretty simple stuff.

BB

Krezak6

Hhhmm,...So why all the talk of Netflow? Does Orion need Netflow to produce real0time data?

thanks

FormerMember

No, Orion does not need NetFlow to produce real time data. The NetFlow module allows users to see NetFlow data in the routers. NetFlow reveals traffic information. Orion can tell you how much bandwidth is being used by an interface. NetFlow tells you how that bandwidth is being used.

jtimes

Do(s) and Don't(s) while your waiting for the "Executing SQL File: onCoreDatabaseScheme" to complete during the initial run of the Configuration Wizard...

Don't:

Hold your breath...

Freakout...

Cancel the Configuration Wizard (even though it looks like the Config Wizard is not responding)

Do:

Make sure there is allot of available free space on your SQL server (at least 3x the total size of your NetPerfMon.mdf & .ldf files)

RDP into your DB server and watch the tempdb.mdf file grow and grow and grow... (\Program Files\Microsoft SQL Server\MSSQL\Data\tempdb.mdf) Once it stops growing the table splits and DB re-org is almost complete.

Bring up perfmon and watch the avg disk queue length sit well above 100% for a while, once it starts dropping below 100 consistently the table split(s) are almost done

These are just a few suggestions to ease the wait... if you have a large DB

PS: It's going to sit on this screen for a long time (don't let your session timeout!)

8 1 install.JPG

BryanBecker

The one thing I would like to suggest to SW is if it is possible please remove the DB check/work from the poller installs. The NPM install should be the one to do anything that's needed to the DB. Unless it is needed doing the same thing on the poller setup is redundant.

BB

kindbro

So, if I am upgrading to V8.1 and my dB is 29g should I allow a couple hours for the upgrade to complete? Is there a way that I can speed up this install?

FormerMember

Kindbro,

With 29g, it could be 3 or 4 hours based on a few of our bigger customers. Mark is right. There's a big payoff in the efficiency of database maintenance, but you should definitely plan on a long database upgrade.

Denny

jtimes

Long is correct, before doing the upgrade I would strongly recommend that you perform a manual table compact/re-index via the database manager.