Possible causes of Memory leakage!

If the system memory consumption increases and the CPU usage increases, the most likely cause is the system memory leakage.

It is because of Memory leakage that reduces the available memory. When it reaches a critical point, it will frequently lead to garbage collection of virtual machines, and garbage collection is a high CPU consumption operation, so the CPU usage will increase.

 

The system cannot work properly due to the outofmemory problem.

 

 

Start or stop sqlserver:

Restart the IIS and sqlserver commands IIS:
Net stop IISADMIN/y
Net start w3svc
Or iisreset

Sqlserver:
Net stop MSSQLServer
Net start MSSQLServer