Forefront TMG 2010 , Controlling High SQL Memory Usage !

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