Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Network Performance Monitor (NPM) > Unable to open new database connection

Unable to open new database connection

Overview

The traps are not visible in Trap viewer. The following message is received:

 

Error:
Service was unable to open new database connection when requested.

Exception 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.


Connection string - Data Source=naag01.corp.service-now.com\MSSQL2012;Initial Catalog=SolarNPM;User ID=sql_solarnpm;Password=*******;Connect Timeout=20;Load Balance Timeout=120;Application Name="Solarwinds Trap Receiver Service";Workstation ID=SJC4SOLAR02

 

Environment

NPM V11 through version 11.5.2

Cause 

Database connections have run out of pooled connections. Theoretical maximum is 100 connections per process (default Connection Pool limit). 

Resolution

SolarWinds recommends to increase the connection pool size on the Main Poller as this hosts Traps\Syslogs and Alerts Services.
This could also be applied on Additional Pollers or any additional Web Server, if needed.

 

  1. Create a back up of SWNetPerfMon.db located in c:\programfiles(x86)\solarwinds\orion\swnetperfmon.db, in case you need to roll back later.
  2. Edit the SWNetPerfMon.db using notepad or any text editor, to have Max Pool Size = 1000..You need to  add the following line before 'Persist Security Info=': Max Pool Size = 1000;
    Note: You only need to edit the top 3 strings, as the product has archived the connection strings not used in the file.
  3. Save the file and exit.
  4. Restart the Orion Services using the Orion Service Manager.
Last modified
02:42, 30 Mar 2017

Tags

Classifications

Public