What is the best configuration settings for DB connection pool for an instance with 1.3 lakh issues?

[Sami Ahmed Shaik]

Hello there,

Welcome back from Holidays!! :)

We are using JIRA Software Server and we have an almost 122519 issues in our instance. We are facing very frequent slowness in the issue processing and JSD queues, even DB connection pool shows high spikes graph everyday.

Please help us to configure the best DB connection pool settings.

<pool-min-size>nn</pool-min-size>
<pool-max-size>nn</pool-max-size>
<pool-max-idle>nn</pool-max-idle>

Have A Nice Day!

Regards,

Sami Ahmed Shaik.

[Gonchik Tsymzhitov]

Hi! 

@Sami Ahmed Shaik  did you experiencing the problem?

[Daniel Ebers]

Hi @Sami Ahmed Shaik

while a closer look at the database is a good idea I would not neglect other aspects as the base system (hardware/sizing of your virtual machine) along with the settings for your JVM (setenv.sh/setenv.bat).

Tuning performance is not a one-shot but commonly needs gradual optimizations - if you want to share information about your installation as referred above Community is likely able to say something, at least as a rough guideline.

More general information are available from knowledge base:
https://confluence.atlassian.com/jirakb/troubleshoot-performance-issues-in-jira-server-336169888.html

Regards,
Daniel

[Sami Ahmed Shaik]

@Daniel Ebers& @Gonchik Tsymzhitov 

Thanks for your response.

@Daniel Ebers 

I hope the following information could be helpful

Application Server: Windows 2016

RAM: 32 GB

Memory: 500GB

JVM Memory: Min: 2GB & Max: 8GB

JVM Version: 1.8

LAN: 10 Gbps

DB Server: Windows 2016 & MSSQL Server 2014

Cores: 12 Core Processor

RAM:16 GB

Memory: 530GB

Regards,

Sami Ahmed Shaik.

[Daniel Ebers]

From the books JVM min memory and JVM max memory should be set to the same value.
Although it is had to tell from the outside you could assess those values further.
A heap that is too large can have negative effects of performance, so, as long as you are not facing out of memory situations I would choose a small value for JVM heap size (min and max) and increase gradually.

Like stated earlier this is a complex issue where many aspects need to be considered. That was only just one sighting.

Which garbage collector do you use?

[Sami Ahmed Shaik]

Based on our current instance performance, is it OK to set the JVM as follows.

Min: 4096mb

Max: 4096mb

We normally see performance issue when there are spikes in the DB pool as follows,

How can we fix such issues? any idea @Daniel Ebers & @Gonchik Tsymzhitov 

Regards,

Sami Ahmed Shaik.

[Gonchik Tsymzhitov]

Hi! 

for the best one you can find using increase. 

But if you see spike, better to find the bottle neck. 

Why RDBMS response slowly? Is this some add-on use non-optimized request?

Did you tune your RDBMS ? 

If you interested you can read that one https://community.atlassian.com/t5/Data-Center-articles/So-when-we-need-to-adjust-configures-for-RDBMS-Or-DB-Performance/ba-p/1393528

Need more info