Please share any images or screenshots, if relevant.
[Please insert images here, otherwise delete this section]
Please share any other relevant files that may be required (for example, logs).
[Please insert files here, otherwise delete this section]
Share all details about your problem, including any error messages you may have received.
Database team is planning to upgrade the SailPoint SQL server from 2019 to 2022. As per the SailPoint IIQ 8.4 installation guide, SQL 2022 is a supported version. However, I just need clarification of few queries:
Have anyone done SQL upgrade from 2019 to 2022 in their SailPoint env.
Did you face any challenges during upgrade ?
Is there anything we need to take care of while DB team is performing the upgrade.
@milinaphalke With regards to 2022, i don’t think you’ll face any compatibility issues. You might want to review the jars, review any DB jobs configured if they can work in 2022 version.
If you have multiple environments, you can start with the lower environments, do the upgrade and execute the modules in IIQ to make sure they all are working fine.
Yes, we will be taking a backup. In our case, it is completely a new WINDOWS server where SQL server 2022 is installed and SailPoint IIQ will now point to new servers.
We are seeing performance issue while running the Database Performance task. Support team suggested few things, but DB team mentioned its already in place.
We are currently using SQL server driver mssql-jdbc-13.2.0.jre11.jar and the latest driver available is mssql-jdbc-13.4.0.jre11.jar.
Other env details are as follows:
JAVA version: open JDK version 11.0.13
App server version: 9.0.56
Do you recommend to upgrade the driver to latest ?
Yes, I would recommend upgrading the Microsoft SQL JDBC driver from 13.2.0.jre11 to 13.4.0.jre11, especially since:
You have moved to a new SQL Server 2022 instance
Your experiencing performance issues (DB Performance task is a good indicator)
The newer JDBC drivers include:
Better SQL Server 2022 compatibility
Performance optimizations
Bug fixes related to connection handling and metadata queries
With Java 11 and Tomcat 9, upgrading the driver is low-risk and fully supported.
Suggested approach:
Test the new driver in a lower environment first
Replace the JAR in Tomcat’s library
Restart the app server
Re-run the Database Performance task and compare results
No other SailPoint changes are typically needed. If performance improves, you’re good to roll forward. If not, it at least helps rule out the JDBC layer and focus further on SQL tuning (indexes, IO, CPU, memory).
I think the overall upgrading to SQL Server 2022 for IIQ 8.4p2 is a well-supported path. The key to success lies in planning, thorough preupgrade backups, careful post-upgrade validation (especially of compatibility levels and JDBC drivers), and comprehensive testing of your IdentityIQ environment. By following step by step approach, can confidently move forward with your database upgrade.
New windows servers are procured and SQL server 2022 is freshly installed on it and then the data is copied from old database server (SQL server 2019) to the new database (2022) on new server.
I see you mentioned “No specific config changes are required unless they are building a brand new DB server for you.” So, in our case it is a brand new DB server. So, does it mean any specific config changes are needed?
@milinaphalke Major work is at DBA end. As you are using Microsoft SQL, you might want to check how DR setup is configured, normally you setup Always On Availability which keeps your servers synchronized. If there are any DB jobs you have written, you need to update them as well.
On IIQ front, you need to update iiq.properties if there are any change to the DB URL, other wise that’ll not needed.
Based on your previous posts, you mentioned that you decided to go for upgrade due to some performance issues. Could you please specify what are those?
Thanks @haideralishaik We have placed the latest sql server jar (mssql-jdbc-13.4.0.jre11.jar), still the DB performance test results are not within the benchmarks given by SailPoint.
@milinaphalke I am still curious.. This task helps you figure out if you have issues with your DB transactions via IIQ but this should not be the only factor to decide if you need to upgrade or not. Please evaluate carefully to decide if upgrade is really going to help you with your concerns or not.
Could you please specify what all additional things you have tried so far.
Hello @neel193 Sorry for the confusion if any due to above communication. DB version upgrade from 2019 to 2022 is not done by SailPoint team. It is an intiative by DB team where they are upgrading all their SQL server 2019 env to SQL server 2022. We as SailPoint team are just performing testing to see there is no impact on SaiPoint application.
@milinaphalke From the screenshots, it looks like in v2022 it is worse than v2019. Do you know other than upgrade, if there is any other change being made to infra: at application server, DB server, network, firewall, or any other thing?
