SQL SERVER 2019 resource locked and ram utilization still constant

Hassan Naeem 1 Reputation point

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,294 questions
{count} votes