How many tables IPAM module creates on the database

Question

Hi, 
 We are looking to deploy the IPAM module on a shared SQL server which have NCM database & many other databases shared by other application. This is a SQL Server enterprise and can't increase the resources on this server. Would there be any performance issues if we deploy IPAM database on this server? 
 Also, another option we have is to we can have another SQL standard database server and we can move the NCM database on this server and deploy the IPAM module also on this database server. But, here we have to move the NCM from SQL enterprise to SQL standard DB so not sure if there would be any issues in migration or performance issue since we are downgrading from SQL Enterprise to SQL Standard. Can you please enlighten which is better option. 
 
 Regards, 
 Daya

Seashore · Accepted Answer

Hi, 
 Even though you provided good information it's still impossible to say. Those other 70+ databases could be huge or tiny. The size of them and the current load on SQL will decide what you need to do. 
 Around 70 db's and probably some of them have some size, I would say that 128 GB RAM is probably a bit to little as it is. 
 Adding IPAM will not, in my experiance, put a high extra load on SQL. If Orion is running ok right now I would add IPAM at current SQL. Try that and if it feels to slow you can plan to move it later.

How many tables IPAM module creates on the database

Top Replies