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

Avyayah 1,271 Reputation points
2024-05-30T20:21:57.94+00:00

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
    2024-05-31T05:21:32.24+00:00

    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.

    See https://techcommunity.microsoft.com/t5/sql-server-support-blog/sql-server-2014-8217-s-new-cardinality-estimator-part-1/ba-p/318249

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points
    2024-05-31T03:20:15.7933333+00:00

    Hi @Avyayah.

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

    All the job are slow or just a few?