The following are possible issue and resolutions that have been reported by customers on MSSQL:
Issues:
1. The upgrade gets stuck at the following line in the install.log: "Loading registered objects for building blocks bootstrap..."
2. Performance issues navigating the application and portlets
CA PPM 15.4.1
Microsoft SQL Server
One or more of the resolutions will need to be performed by the DBA team:
1. Check the database transaction logs to see if there is a specific error.
2. Set the max degree of parallelism:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-2014
3. Set the compatibility mode:
https://docs.microsoft.com/en-us/sql/relational-databases/databases/view-or-change-the-compatibility-level-of-a-database?view=sql-server-2014
4. Database analysis and maintenance