Jobs are running slow in sqlserver that was upgraded from 2012 to 2019

Avyayah 1,271 Reputation points

Set the max memory to 34076MB for 4 core and 38GB RAM. what other sql adjustment can be made so that the jobs run fast. 94% of memory is used.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,086 questions
{count} votes

Accepted answer
  1. Olaf Helper 42,486 Reputation points

    With SQL Server 2014 a new cardinality estimator was estimated, could be possible now decide to execute the queries in a different way = different execution plan. You have to dig deeper in it.


    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points

    Hi @Avyayah.

    It could be several reasons, what's your windows system?

    All the job are slow or just a few?