E-MS SQL Why slow Query Performance After Upgrading To SQL Server 2012 from 2008?
(Doc ID 2524650.1)
Last updated on NOVEMBER 25, 2019
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.
Slow Query Performance after upgrading to SQL Server 2012 from 2008 ms sql.
8.53 Tools.Database upgrade performed to MS SQL 2012 db release.
Slow Query Performance after upgrading database. Serious issues running queries within PSHR.
Some report ran much faster then before on 2008 and need this resolved asap.
Slower overall system performamce.
Query run times went from minutes to hours and there are times the queries don't run at all or have to be killed because they are causing blocking sessions
With the higher server release to have better performance then the ms sql 2008.
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