Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / CRM 365 max pool size ...
Customer experience | Sales, Customer Insights,...
Answered

CRM 365 max pool size was reached

(0) ShareShare
ReportReport
Posted on by Payman Biukaghazadeh 55

Hi there,

We have installed CRM 365 for our production environment. Three machines used:

  • DB: 64 GB Memory, 24 Core CPU
  • Frontend: 32 GB Memory, 16 Core CPU
  • Backend: 32 GB Memory, 24 Core Cpu

As indicated, the resources are good enough and no lack of resources occur. We have daily number of 80K cases in CRM and 700 users working with system.

Every time our CS experts try to assign 100 cases, the following error occurs:

The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.

I have checked lots of records in deployment properties table and also check the config files, but could not find any configuration to be able to handle this error.

  • Verified answer
    Venkatesh Nadar Profile Picture
    Venkatesh Nadar on at
    RE: CRM 365 max pool size was reached

    IIS reset will be enough.

    Sorry, the column name is Intcolumn, try the below query-

    insert into organizationproperties (Id,ColumnName,IntColumn) values ('ORG GUID','SqlConnectionMaxPoolSize',300)”

    Regards,

    Venkatesh N

  • Payman Biukaghazadeh Profile Picture
    Payman Biukaghazadeh 55 on at
    RE: CRM 365 max pool size was reached

    I have tested this one and set it to 5000, but no chance. Just to double check: iisreset is enough for this change to take effect? Or I should reset both db and backend severs?

  • Venkatesh Nadar Profile Picture
    Venkatesh Nadar on at
    RE: CRM 365 max pool size was reached

    Hi,

    Use the following select to show the value (targeted DB is the MSCRM_CONFIG) select * from  deploymentproperties where ColumnName='SharedDBConnectionPoolPerOrgLimit'

    The default value is 100, the update query has been set for 300, but can be edited:

    update deploymentproperties set IntColumn=300 where ColumnName='SharedDBConnectionPoolPerOrgLimit' insert into organizationproperties (Id,ColumnName,BitColumn) VALUES ('GUID','SqlConnectionMaxPoolSize',300)

    Regards,

    Venkatesh N

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans