How to release RAM memory without restarting services

[kikani.kautik]

Hello Masters,

My sql server has 24GB of RAM, I got alerts from windows team that SQL Server consuming about 99% of memory ! SQL server is connected with many applications so its not possible for me to restart services of sql server.

Is there anyway that it will release memory without restart ?

 

[terry4536]

I'm not familiar with SQL server. If you are running it in Windows, then you can use Task Manager. Just open Task Manager, and then on the Processes tab select that application and use the End Task button at the bottom of the page.

 

[kikani.kautik]

I'm not familiar with SQL server. If you are running it in Windows, then you can use Task Manager. Just open Task Manager, and then on the Processes tab select that application and use the End Task button at the bottom of the page.

This is not a solution,

I think you can not understood my question, okay np !!!

server is connected with many applications so its not possible for me to restart services or end task of sql server



Thanks

 

[boju]

No, not ram. Maybe higher end server motherboards possibly, albeit i doubt it somehow.

https://en.m.wikipedia.org/wiki/Hot_swapping

 

[terry4536]

Try this.

https://docs.microsoft.com/en-us/sql/ssms/agent/stop-a-job?view=sql-server-2017

 

[terry4536]

Or this.

https://docs.microsoft.com/en-us/sql/ssms/agent/start-stop-or-pause-the-sql-server-agent-service?view=sql-server-2017

 

[kikani.kautik]

i got an answer from internet.. it's resolved

Thanks for your answer

 

[terry4536]

How did you resolve it?

Was the Microsoft SQL Tool website helpful?

 

[kikani.kautik]

How did you resolve it?

Was the Microsoft SQL Tool website helpful?

yes i have contact to Microsoft community