Recently I deployed Forefront TMG 2010 in my company, and I was facingĀ High memory usage by sqlservr.exe which was using over 1.5 GB of memory. So I limit its usage by using following method.
Open Command Prompt on TMG server and enter the following command,
osql -E -S localhost\MSFW
Now paste the following text, (Before pasting, you can adjust the memory size like 512 means 512 MB, if you want to set 1 GB limit, you can use 1024 value.)
USE master
GO
EXEC sp_configure ‘show advanced options’, 1
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure ‘max server memory (MB)’, 512 –configure 512MB limit, adjust it as required
GO
EXEC sp_configure ‘show advanced options’, 0
RECONFIGURE WITH OVERRIDE
GO
Now open Task Manager and see the sqlservr.exe memory usage.
.
For more info, Use the below article at Richard Hicks Blog.
http://tmgblog.richardhicks.com/
*
Regard’s
Syed Jahanzaib