How to monitor pool (Max Pool Size=1000;)

Hi All, I want to know how to monitor pool (Max Pool Size=1000;)

Event Error messages: Service was unable to open new database connection when requested. TransactionManagerCommunicationException: Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool. Connection string - Data Source=xyz;Initial Catalog=SolarWindsOrion;Persist Security Info=False;User ID=xyz;Password=*******;Max Pool Size=1000;Connect Timeout=20;Load Balance Timeout=120;Packet Size=4096;Application Name=SolarWinds.Alerting.Service@SolarWinds.Alerting.Service.exe;Workstation ID=ABC

Parents
  • Following this thread to see if anyone gets a straight answer. I was given the "build a bigger database server" response when my DBAs only see about 40% utilization of our current setup. They did double my available RAM on the SQL box but we're still seeing the errors with the same frequency but with even lower utilization numbers on the SQL box.

Reply
  • Following this thread to see if anyone gets a straight answer. I was given the "build a bigger database server" response when my DBAs only see about 40% utilization of our current setup. They did double my available RAM on the SQL box but we're still seeing the errors with the same frequency but with even lower utilization numbers on the SQL box.

Children
No Data