Network App SolarWinds DB instal?


Thanks everyone for reading.

I'm installing multiple Orion modules i.e UDT, SAM, NCM and NPT onto a remote SQL server. The admin guides are really thin on the installation part so I wanted to ask if I should put all modules onto the same database for ease of backup? I'm pretty sure that was in some admin or best practice guide but I can't reference it at the moment. Just wondering what you guys do?

Thanks again
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Leon AdatoHead GeekCommented:
Most SolarWinds modules (NPM, SAM, NCM, etc) are designed to use the same database, and to install on the same server. For the modules you named (UDT, SAM, NCM, and NPT, which I assume you mean NPM) all work together. Depending on the size of your environment, you will need one server to run the Solarwinds software, and a separate server running MS-SQL.

One thing that lots of people overlook is that SolarWinds (and monitoring tools in general) make a HUGE number of very small reads and writes. That means the disk system you put the database on is critical - it has to be fast, and it REALLY REALLY shouldn't be RAID 5. Either go with RAID 0 (disk mirroring) or RAID 1+0.

Let me know if you have any other concerns. You can also find a ton of great information over at the SolarWinds community -
snyderkvAuthor Commented:
Thanks Leon, just wanted to point out that NTA does suggest to install on a separate server but we are doing it local. We have less than 1000 nodes and the default retention.
Leon AdatoHead GeekCommented:
You didn't mention you had NTA. Yes, for that another server is recommended - to process NetFlow data in realtime. So in that case:
1 virtual server as the primary poller.
1 physical server with local disk as your database server
1 virtual server for the Netflow flow processing server.

that's your optimal design. You may be able to get away with combining the primary poller and flow storage if you aren't processing too many flows.

Remember, the success of your monitoring solution rests partially on its ability to scale to the data processing needs of the environment . I've watched several SolarWinds installations "fail" because the admins didn't want to face up to that reality.

Good luck, and keep me posted!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
snyderkvAuthor Commented:

We have two flows for now but may have 6 flows in the future? Does this sound small enough to justify a local install?

I'm thinking we can run all modules with 16GB ram, 4cpu connected to a remote database (NTA recommended) I can always scale out in the future
Leon AdatoHead GeekCommented:
The answer to "is it big enough" is "as long as you can grow it later if necessary."

2 to 6 flows doesn't sound like TOO much as a start.

The NTA recommendation you quote is (I believe) for the flow storage processor only. You have to figure that you are running all those other modules on the same box. I would start with 16Gb RAM and 8 CPU. Another factor is the speed of the CPU - there is a HUGE difference between 2.7Ghz and 3Ghz that can't be made up by throwing more CPU at it.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Network Management

From novice to tech pro — start learning today.