Documentation forServer & Application Monitor

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:

  1. Log into the polling engine.
  2. Navigate to the default installation folder: C:\Program Files (x86)\SolarWinds\Orion\APM\
  3. In a text editor, open SolarWinds.APM.Probes.dll.config
  4. Change MaxPoolSize to any number, 1—5.
  5. (Optional) Adjust the ConnectTimeout setting; the default is 60 seconds.

  6. Save your changes.
  7. 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 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.”