My Oracle Support Banner

E-MSS: Performance Issues After MSSQL 2017 Upgrade (Doc ID 2644045.1)

Last updated on APRIL 03, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Performance issues on batch processes after MSSQL 2017 upgrade
After upgrade to MSSQL 2017 and application of PeopleTools patch to 8.56.18, processes are running slower than before upgrade.
What settings at database level or process scheduler level can be adjusted to gain performance?



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.