We currently run NPM 9.1 on a powerful box; however, we've noticed that, with the addition of various modules, the back-end SQL server (also on the same box) is consuming more and more resources, such that the front-end website is running extremely slowly.
We're thinking of splitting the workload among two servers: the backend would contain SQL server. A second, smaller box, would contain the actual application, modules, and polling engine, plus the website.
Alternatively, and more preferably, we'd like to keep SQL and possibly the polling engine on the more powerful box, and move the apps and website to the smaller.
Is this feasible? In essence, we'd like to know what resources can exist on separate servers, and what need to coexist on the same box.
Any help or insights would be appreciated
