MS sql server is showing CPU 98% and Memory 99%. This is sql server 2016.
I didn't some testing. When i disable application user, the cpu and memory is coming down to just 5-10%, but at the moment when i enable applicaiton user, within 5-10 mins CPU and going to 99%. when when i run SP_who2, i found lot of blocking.
Please go thourgh the screenhot and suggest us, how to resolve.