This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 55.00000000000001%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
It looks like it is a know issue and we do not have a test instance. All database compatibility levels are set to sqlserver 2019 (150). Auto create Incremental statistics are set to False.
You can always try pressing the go-faster button.
Seriously, with zero information about your environment, there is no way we can give you a sensible answer. You need to describe your problem in more detail.
We have upgraded from 2012 to 2019 and some of the sqlagent jobs are running running extremely slow. These are the jobs that are reformatting and populating the production database. The server has 4 code and 38 GB RAM
I guess you need to get your hands dirty with these jobs to find out what they are doing then.
Or do you expect us to have a solution despite not having any knowledge about your system? May kindly remind you that this is a forum for peer-to-peer support. It's a not a training camp for ladies with a crystal ball.
What sort of jobs are these?
What is the compatibility level of the database?
These are sql jobs formatting the tables in the database. Compatibility level is set to 150
I'm sorry, I've heard about formatting disks, but I've never heard of "formatting tables" in SQL Server.
I was more asking if they are T-SQL job steps, SSIS packages etc.
If you change the compatibility level to 110, do the jobs run faster?
Does it require restart of the database server if I change the compatibility level?
No, it does not.
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.
Hi @Avyayah.
It could be several reasons, what's your windows system?
All the job are slow or just a few?
Some jobs are slower, I guess I need to create execution plan and check on what causing the jobs to run slow.