Post reply

performance issue in 2014 with peoplesoft application

  • September 30, 2018 at 5:07 am

    #415753

    Hi,

    We upgraded the sql server 2008R2 server to sql server 2014(side by side) along with OS, peoplesoft application. now we are facing performance issue. the job which is taking less time in current PROD is not same in new SIT., its taking more time..

    any idea on this?

    SQL server 2014 sp2 with CU10,
    OS 2012
    application peoplesoft.

  • October 1, 2018 at 12:01 am

    #2007454

    It could be a ton of things. The best approach is to capture wait statistics and query metrics to understand what is running slowly and why. However, a likely possible issue is the new cardinality estimation engine in 2014. Are you running in 140 compatibility mode? As a short-term experiment, see if the database performs better in the older compatibility mode.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply