NumActive connection pool increased dramatically after Jira Software

[Artem Semenov]

The pool of NumActive connections increased dramatically after the upgrade from Jira server software to version 8.13.7 and from Jira server SD 4.13.7. Previously, this value could range from 0 to 3, and after the upgrade, there is a constant value of Num Active from 5 or more. How critical is this? The database is Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.50226.0 (x64). I would appreciate an answer.

[Brant Schroeder]

@Artem Semenov - It looks like you are having some stuck threads.  I would work with your DB to see if you can see which queries are hanging and taking a long time to clear.  You should also check your logs as well and see what changed since the upgrade. 

You can also take a look at this as it could be the issue https://confluence.atlassian.com/jirakb/jira-is-running-out-of-database-connections-frequently-on-ms-sql-server-816682427.html

[Artem Semenov]

Hello @Brant Schroeder

I checked the database as indicated in the link

SELECT is_read_committed_snapshot_on FROM sys. databases WHERE name= 'JIRA-DATABASE';

the request returned 1.

I can send you logs and configuration files if this helps clarify the reason. Unfortunately, I can't provide the database itself, because the security policy does not allow this.

[Brant Schroeder]

@Artem Semenov No need to send the DB. As far as the log goes are you seeing any errors or stuck processes over and over again?