Increase the number of AppInsight for SQL connections to speed polling
Starting in SAM 2020.2.6, you can boost the speed of AppInsight for SQL polling by increasing the number of SQL connection pools used by the Main Polling Engine or individual Additional Polling Engines (APEs). Up to five connections are supported.
To increase the number of connections used by AppInsight for SQL polling:
- Log in to the polling engine.
- Navigate to the default installation folder:
C:\Program Files (x86)\SolarWinds\Orion\APM\
- In a text editor, open
SolarWinds.APM.Probes.dll.config
- Change
MaxPoolSize
to any number, 1—5. -
(Optional) Adjust the
ConnectTimeout
setting; the default is 60 seconds. - Save your changes.
- Use the SolarWinds Platform Service Manager to restart the JobEngine service on the polling engine.
If the following message appears in the Database Details widget on the SQL Database - Summary page, adjust MaxPoolSize
and ConnectTimeout
settings:
No valid date was received. Timeout expired. 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.