Server Management - Systems Insight Manager
1832961 Members
3356 Online
110048 Solutions
New Discussion

Re: multiple HP SIM databases on same database server

 
rijsbergen
Frequent Advisor

multiple HP SIM databases on same database server

Hello,

since the HP SIM Windows installation adds a unique number to the database name i assume i can add multiple SIM databases of different installations to the same database server?

Any known restrictions on either MS SQL or Oracle?

e.g.:
- 2 separate HP SIM Windows to same SQL instance
- HP SIM Windows and a SIM Linux to the same Oracle server

regards
Regards,
Marcel Rijsbergen
1 REPLY 1
Derek_56
Valued Contributor

Re: multiple HP SIM databases on same database server

Marcel,

I'm unsure about the Linux and Oracle implications, but I am running our multiple SIM installations to a single, central MS SQL Server. The real concern of this setup is to ensure your database server is properly sized and has adequate network, disk, CPU, & memory resources to handle the influx from multiple application instances. It would also be smart for you to ensure that any mass database writes/reads, like those done by a data collection, inventory, or identification tasks from multiple instances are scheduled out so they don't run at the same time. Good luck.

Derek