I know that the Failover Service on SDP implements a hot-standby system, meaning that a primary server runs by keeping a secondary server in standby mode. But are there any possible ways to make the secondary server operate   simultaneously with the primary one ?

I want to deploy SDP servers as an active-active system because in my experience, the primary server went slowly when the number of employee requests increased significantly during peak periods, which felt similar to a self-induced DDoS load on the primary server.

I really want to know whether SDP supports any form of load balancing or horizontal scaling (active-active), or if there are recommended architectures to distribute traffic across multiple SDP nodes? If not, are there any best practices for optimizing performance under heavy load, such as database tuning, application-level caching, or deployment guidelines for high-traffic environments?