Note:

•For systems with more than 100 measuring points, it is recommended to install the database and RMS web server on separate computers. Smaller systems can also achieve better performance this way.

oSecurity: Implement a DMZ setup for your web server, granting access from the public internet and handling untrusted input from anonymous users. Adhere to least privilege principles for database connections to limit potential exposure in case of a web server compromise. Introduce a business tier for an extra security layer between attackers and your data. Conversely, if your database shares the same server, a compromise provides the attacker with root access to both data and server.

oScalability: Opt for a stateless configuration for your web server to effortlessly achieve horizontal scalability. Scaling a database server horizontally, however, poses a significant challenge.

oPerformance: Boost overall performance by deploying two separate boxes, doubling the CPU, RAM, and spindles for disk access. This setup enhances system capabilities and responsiveness.

•Please note that live monitoring and the alarm functions stop working completely when the database or web server is shut down (e.g. for a Windows update). If this is not acceptable, both servers must be implemented redundantly.

•SQL Express allows a maximum database size of 10 GB. This corresponds to about 200 million measured values. For larger volumes of data, the commercial SQL Server version must be used.