Syed Jahanzaib Personnel Blog to Share Knowledge !

May 17, 2012

Forefront TMG 2010 , Controlling High SQL Memory Usage !

Filed under: Forefront TMG 2010 Related — Tags: , , — Syed Jahanzaib / Pinochio~:) @ 5:00 PM

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

The Silver is the New Black Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 2,295 other followers