SQL Server Load

1

Hi,

The application team is pushing more than 7 lakhs records per day to SQL Server. The SQL Server version is 2016 with ALWAYS ON. During one point of time the SQL Server hungs and I need to failover manually.

  1. How much load can SQL Server withstand
  2. How much connections can it take at a time