Hello,
Does NPM have only one database schema (NetPerfMon)?
Is there a way to change the name to create and differentiate between multiple database tables?
Thanks in advance.
I think that NPM have only one database schema. I mean you can use only one database connected by NPM at the same time. When you run Config Wizard you may create new database or change the name of default while configuring NPM but remember that database keeps all of your configuration critical information (licensing, polling servers, db maintenance settings etc.), so you cannot switch or select the database on running system.
Meaning that on any one SQL instance there is only one NPM database (named NetPerfMon) and I cannot create another one with another name (i.e. NetPerfMon2).
In that case, the only way to run two NPM databases on the same machine is to do another SQL instance on another drive partition which is not really advisable. That would probably give the server a heart attack and shut down both NPM services.
Do I understand this correctly?
You may create another database on the same SQL instance (for instance "newOrion") but you cannot use them both at the same time. To use another db you will have to run Config Wizard each time while switching between dbases, I think. But then you will have lost data in one db when using other.
I'm just wondering why you want to change database?
I guess I left out some pertinent information. In my environment there are two network groups from two agencies with some shared resources. Both groups have their own, separate Orion NPM app servers. The other group owns a server farm with a SQL cluster that has room for another database but on the same physical server as their existing NPM database. I had a previous Orion installation on my own separate, physical servers which were not compromised by SUNBURST but out of an abundance of caution my leadership is requiring new hardware if we are to continue using Solarwinds.
In building my new Orion NPM deployment I am considering placing my database on their SQL cluster but since it would have to go on the same physical server as their NPM database we have to make sure that we can have two different NPM databases with unique names active on the same SQL instance. If we have to run two instances, that will be a show stopper.
In summary, is it possible to simultaneously run two separate (physical) Orion NPM app servers using two separate databases with unique database schemas on one SQL instance? Or does Orion NPM name its database "NetPerfMon" and not allow that to be changed?
