Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Why is the performance so slow? Edited

Hi,

I have tried any suggested improvements, but the general Jira performance is very slow. I've installed Jira on an virtual application server (VMWare - Windows Server 2012) with sufficient performance. Currently we have ~300 tickets and 10 custom fields.

Does it make sense to switch to cloud? Do I have access to my internal database for connection to my articles and customers (Plugin Power Database Pro)?

 

Please can you help me?

 

P.S. Sorry for my english :)

3 answers

3 votes
Daniel Eads Atlassian Team Apr 24, 2019

Hi Thomas,

I realize this thread is fairly old at this point but wanted to provide you with some extra information if you were still considering Atlassian Cloud.

Based on the size of your Jira instance, I think migrating to Cloud could be a great move. This would offload the heavy administration work to Atlassian - things like ensuring HTTPS is configured correctly, getting maximum performance out of the database, and handling backups.

You mentioned that you’re using a plugin on your existing Server instance to bring fields in to Jira from an existing external database. I’m currently aware of a marketplace app called External Data for Jira Fields which will let you do the same external-database-to-Jira-field pull for Cloud. Many other use-cases covered by other Server plugins have Cloud options now as well.

Hopefully this is helpful for your consideration if you’re doing any Server administration work in the future!

Cheers,
Daniel

1 vote
Thomas Deiler Community Leader Jan 30, 2018

Dear @Thomas Stockinger,

first, performance is sometimes a subjective "feeling". Can you give me some numbers of how long a specific request takes time? 2ms  or 10sec ...

It can have many reasons - a remote diagnosis is hard to to, but the more information your provide about your environment, the better we can help.

So long

Thomas

Hi Thomas,

the loading time of a ticket is 20 -50 seconds. Open the dashboard after ticket opening is 15 - 30 seconds. For example, when i try to open the system informations within the admin center it takes 50seconds...  Following you can find information about the application server:

Virtualization: VMWare

OS: Windows Server 2012 R2

RAM: 16 GB (Utilization ~50%)

CPU: 4 virtual cores / 2 sockets (Utilization ~5%)

DISK: 150GB (SAS - 15k)

 

The version of Jira is 7.7.0. Following you can see the actual storage overview.Unbenannt.PNG

The jira is configured with ssl.

 

BR, Thomas

Thomas Deiler Community Leader Jan 31, 2018

Dear Thomas Stockinger,

the loading time is definitely too long. To find the reason you have to check everything from the roots, far before Confluence.

My recommendation:

Do other clients (from other PCs/notebooks) have the same experience? If yes, there could be a network infrastructure problem, for example traffic shaping (QoS). WiFi could be also bad, if many radio cells are overlapping.


Then try to measure the network throughput with tools like netcat. I am only familiar with Linux, but I guess there is a similar app that can send files back and forth from client to server. Best on a low level, just TCP/IP no protocols on top. If this is also slow, my suspect is the network. Try tor repeat the the speed measuring with a different server, or from different client. Is it the same?


Then if have excluded the whole network and networking hardware, you can focus on application layer. Is there a proxy in front of Confluence? What are its settings? Any limitations?


What about the database? Is it located on same host? When Confluence has to wait for the DB, then the whole request will take long? Does the DB respond quick enough?


All above is pretty fast? Then you are close to Confluence. First install a page load analysis add-on for your browser. Search for "performance" - there are different out they. This add-on will give you more details where the time is lost during a page load.


I am glad to here from your investigations.

So long

Thomas

Hi Thomas,

 

thank you very much for your help.

The performance issue is solved. The cause is my network speed between my application server and my database server. After changing the database to H2 the performance is very fast.

H2 is not the best one but the performance issue is solved.

So thanks again !!!

 

BR, Thomas

ARGH!  NO NO NO!

H2 is NOT suitable for a production system.  You could suffer a catastrophic data loss with zero warning and lose the lot (also, it's not going to scale if you're heading for a medium or large system)

If it's a dev/test system where you don't mind having to start from scratch irregularly, then h2 is fine.

OK OK :)

I will install mysql directly on my application server and try again.

 

Thanks for your comment.

 

Br, Thomas

Thomas Deiler Community Leader Feb 01, 2018

Dear @Thomas Stockinger,

hey congratulations, that you fixed the issue! But I am really interested, what made the connection to your DB that slow? Was it a bad NIC? Only 10MBit?

So long

Thomas

0 votes

Hi Thomas,

how does the bad performance make itself noticeable?
Many seconds until an issue loads?

Performance can be affected by many factors.

300 tickets and 10 custom fields is not very much. I assume there are neither many users working on your Jira.

You ruled out network and server issues. Have you followed the official Performance Troubleshooting Guide yet? Troubleshooting Performance Problems

Do you have any external applications integrated into your Jira? Any scripts enabled by add-ons?

Regarding Jira Cloud: You don't have access to the database in Atlassian's Cloud offerings. Pros and Cons of Cloud vs. Server

Hi Niklas,

please see comment above.

I've tried several solutions within the troubleshooting description. But I could not see any performance improvement. My log files show no warnings or error messages. Regarding to external applications: I've installed Confluence but currently it's only accessible for me and confluence is not connected to Jira. I bought a plugin for Jira "Power Database Fields PRO",  because I want to make our customers and article data selectable in a claim process. Currently the plugin is deactivated regarding to my performance problems. 

Thanks for the information about Cloud vs. Server. So now I know the cloud is not an alternative. 

I have a great suspicion that the switch to HTTPS is the possible cause.

BR, Thomas

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

4,459 views 5 15
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you