question

hassan174 avatar image
hassan174 asked

SQL SERVER 2019 resource locked and ram utilization still constant

Migrated from Sql Server 2016 to 2019 after migration with the increasing load sql server is blocking the resources and ram utilization is not increasing but CPU is going to 100% but in 2016 same procedure/query increased the ram usage upto 80% but in 2019 it is not going more than 10% and deadlocks are happening. This is causing serious deadlocks to happen.

Server Specifications Windows Server 2016 Sql Server 2019

sql-server
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.