My previous post focused on the specific issue of poor PS Query performance when ARITHABORT was set to OFF on the connection.
But the fix I suggested for that will also affect all other Peoplesoft connections. That means app servers, process schedulers, app engines, BI Publisher reports …pretty much every PS connection. But that really is what you want ….
EXEC sys.sp_configure N'user options', N'64' GO RECONFIGURE WITH OVERRIDE GO
is your friend 🙂
But remember to test it first …. 🙂