Constant SQL queries

We use SQL Server to host our JIRA db (now on 2012, was 2008 previously). We never really noticed a performance issue with SQL Server before but a problem unrelated to JIRA caused us to do a performance analysis on our db server. I noticed that JIRA is constantly making calls into the database on the order of once every few ms and makes the logs hard to process, it is always simple queries:



3) select 1

Is this normal? I ran across this question and answer and modified the dbconfig but have not yet restarted the service because it's production hours. Will that take care of 1&2? I know from experience that #3 is more of just a ping to see if the server is alive and the db is accessible. Is there a way to make that happen less often? Thanks!

1 answer

1 accepted

Hi Jeremy,

This is normal and JIRA needs to constantly ping its database to ensure that it's still available. I'm sorry to say that I'm also not aware of any way of reducing the number of times or the time it makes those checks, so instead I would look at a different method of reviewing your SQL Server logs such as using a tool like grep to search and filter the contents of the logging.

All the best,

Thanks for the answer. It's not a big problem since I can filter it out and it's not going to cause any performance issues, but at first glance it certainly did not look like expected behavior considering how frequently it was happening.

Just for reference I did change the connection string in the dbconfig as noted in the original post. I also updated the jtds jar in the lib folders to more recent versions (1.2.7 for JIRA and 1.3.0 for Confluence since they use Java 1.6 and 1.7 respectively). Neither of those two modifications had any impact on this particular issue.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,781 views 11 18
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot