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 into the polling engine.
- Navigate to the default installation folder:
C:\Program Files (x86)\SolarWinds\Orion\APM\
- In a text editor, open
MaxPoolSizeto any number, 1—5.
(Optional) Adjust the
ConnectTimeoutsetting; the default is 60 seconds.
- Save your changes.
- Use the Orion 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
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.”