I’m assessing JIRA for our company work. The official resources indicate support only for SQL Server 2005, and a company representative confirmed that SQL Server 2008 is not completely supported. We are interested in using SQL Server 2008 as it aligns with our standardization strategy. Have any administrators or users experienced challenges when running JIRA on SQL Server 2008? Are there known issues or possible pitfalls we should be aware of? Your feedback is greatly appreciated!
After deploying JIRA with SQL Server 2008 in a test environment, I observed that while the system is operational, it requires additional tuning compared to using the officially supported SQL Server 2005 version. In our setup, query performance and database indexing needed more careful configuration to handle peak loads efficiently. There were some unexpected slowdowns that we resolved through customized optimizations. Overall, using SQL Server 2008 is feasible, but be prepared for potential issues that might necessitate extra monitoring and periodic adjustments to maintain the system’s reliability.