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.