SQL Errors
      Back to home
      1. INTERNAL - Bepoz Help Guides
      2. Troubleshooting
      3. SQL Errors

      MaxPoolSize Reached on SQL Database; Max pool size reached

      Overview

      Problem / Symptoms

      Timeout expired; all pooled connections were in use and max pool size was reached

      ​​​​​​​

      Diagnosis:

      Paste and run the Simple Pool Connection Query

      --Simple Pool Conection

      select * from sys.dm_os_performance_counters

      where counter_name ='User Connections'

      Solution / resolution:

      • Hit the start button        

      • Search for "run"               

      • Type "regedit"  

      • Navigate to Bepoz Registry String              Computer\\HKEY_CURRENT_USER\\Software\\Backoffice

      • Add a new DWORD (32-bit) Value              

      • Name it "MaxPoolSize"

      • Set the Value to "1000" 

      • Hit Ok  

      • Restart Smart Controller