SSRS- Report server connection pool issues.

Hi PK_2020234 

The errors you are encountering in SSRS Version 16.0.8969.32906 on your new server indicate a combination of HTTP runtime issues and database connection timeouts, likely due to high concurrent usage at 4 PM. The System.Runtime.InteropServices.COMException (0x800703E3) error suggests that SSRS is experiencing an issue with processing HTTP responses, possibly due to resource exhaustion or IIS-related settings. Additionally, the Timeout expired error while connecting to the ODS_CAA2 data source indicates that the connection pool is reaching its maximum limit, preventing new connections from being established. To resolve these issues, consider increasing the connection pool size in the data source settings, optimizing the execution schedules of reports to reduce peak load, and reviewing IIS and SSRS memory limits. Also, check for long-running queries that might be holding connections open and configure database indexing or query tuning to improve performance. Monitoring server resource usage (CPU, memory, and network activity) around 4 PM could provide further insights into what is causing the spike in connections. Let me know if you need help with specific troubleshooting steps or configurations!