Hi everyone! I need some advice about running JIRA on SQL Server 2008.
I’m currently looking into JIRA for our team but I’m running into some compatibility concerns. The official docs mention support for SQL Server 2005, and when I spoke with their sales team, they specifically mentioned that 2008 isn’t completely supported yet.
The thing is, our company has already moved to SQL Server 2008 across all our systems, so using an older version would be problematic for us.
Has anyone here actually set up JIRA with SQL Server 2008? I’m curious if you ran into any bugs or performance problems. Even if you haven’t used it yourself but know someone who has, I’d love to hear about their experience.
Any feedback would be really helpful before I make a decision. Thanks in advance!
We deployed JIRA with SQL Server 2008 six months ago and hit some compatibility issues during setup. The biggest problem was transaction isolation levels causing deadlocks under heavy load, but we fixed it by tweaking the database config. Performance’s been solid after we optimized the connection pooling. Atlassian doesn’t officially support 2008 yet, but the database compatibility works fine for production. I’d definitely test your workflows thoroughly in staging first, especially if you’ve got custom plugins or integrations that might behave differently with the newer SQL Server version.
don’t stress about it - our IT guy put jira on sql server 2008 last spring and it’s been solid. got some warning messages during install, but everything works great. way better than staying stuck on 2005 because of old docs.
been usin JIRA on SQL 2008 for a while, and honestly it’s been smooth. got past some indexin quirks but overall, no major probs. feelin confident about it, to be honest.
I set up JIRA on SQL Server 2008 about eight months ago - had the exact same concerns you’re dealing with. Installation went way smoother than expected, even with all those scary warnings in the docs. We hit one snag with date handling that needed a small database config tweak, but nothing that stopped us from launching. I was worried about long-term support, but Atlassian’s been solid when we’ve opened tickets. Performance is actually better than what we had on 2005. I’d say go for it with solid testing, but don’t let the missing official support docs scare you off completely.
I moved our JIRA from SQL Server 2005 to 2008 last year - way easier than expected. Main headache was getting the JDBC drivers set up right for the newer version. Had some connection timeouts at first that needed tweaking in the connection string, but after fixing those it’s been solid. We ran both environments side by side for two weeks to check performance. Ticket loading actually got about 15% faster after the switch. Documentation sucks when you’re troubleshooting issues, but everything works fine overall.