In most cases, a single database server can handle all aspects of the PerfectApps application. However, once the load reaches a certain level, or if excessive load is occurs due to unusually heavy reporting, then you may need to improve database performance.
The following list is sorted by complexity, from easiest to most difficult fixes for database performance. It reflects the order in which you would normally optimize the system over time.
1.Add more memory.
2.Add more processors.
3.Put your transaction logs on separate drives.
4.Put the reporting database on a separate server.
The obvious first step is to add more memory and processors. As PerfectApps was designed for optimal scalability, this should yield good results. The last two options will only be needed for large installations with many users and a heavy load.
Return to: Server Side Hardware Requirements, PerfectApps On-Premise
