The following are possible issue and resolutions that have been reported by customers on MSSQL:
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
Each case is unique, however each reported solution can help in determining a resolution plan.
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:
3. Set the compatibility mode:
4. Database analysis and maintenance