Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server Connection and Usage

Teresa Schroat
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 16, 2020

I have a question about JIRA interaction with a SQL Server and its application databases we manage.   If we have a SQL database that is providing database tables to our application.exe and a JIRA plugin outside of the Server that queries data in one of our tables in that database is performed does that introduce a locked down or inaccessible situation for the application that is using the table /database ie; are there restrictions in JIRA or maybe the environment we are in that would somehow now render the database not accessible because JIRA requires exclusive access?.  Its a conception that if JIRA plugin queries the database that it somehow now requires exclusive use of the database it is querying?  

1 answer

0 votes
Sven Schatter _Lively Apps_
Atlassian Partner
January 16, 2020

Hi @Teresa Schroat,

the short answer is: this probably shouldn't be a problem.

the long answer is: it depends on your DBMS and how it is actually queried. Typically, queries are wrapped in Database Transactions. Transactions can be of different types such as read-only,  read-write, and so on. The DBMS figures out how it has to schedule these transactions so that nothing breaks. As an example: Two read-only transactions could be executed simultaneously without a problem, but a read-only transaction would have to wait on currently running write operations to finish, before it can be run.

What this essentially means is that if there are a lot of read operations by your external app, that doesn't really have an impact on performance or create any locks. However, if your app consistently writes large amounts of data into many different tables in a high frequency, this could very well have an impact on the performance of Jira itself. But this is very unlikely.

Hope this helps!

Sven

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events