Syed Jahanzaib Personal 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

EXEC sp_configure ‘show advanced options’, 1

EXEC sp_configure ‘max server memory (MB)’, 512 –configure 512MB limit, adjust it as required

EXEC sp_configure ‘show advanced options’, 0

Now open Task Manager and see the sqlservr.exe memory usage.


For more info, Use the below article at Richard Hicks Blog.



Syed Jahanzaib


  1. AoA Sir,
    I have recently created a small network of school+madarsa lab. Now, they are asking me to implement such solution that can provide them centralized web blocking of video sites, porn, social networking sites. I do have knowledge how to achieve that target using list of domains or url regex. but they want a server software freeware to do that. Like blue coat k9 web filter (its a single pc software).
    Waiting for prompt response.


    Comment by backupsite — May 17, 2012 @ 8:59 PM

    • You can’t block *ALL* of the porn sites using ACL/regeex method.
      Recently I implemented Forefront TMG 2010 and using its URL Filtering, where its possible to block any site based on pre defined category (maintained by Microsoft Reporting Center) , Its the most suitable method I have found ever. However its not the free method. If you wanna go free, go with Squid Filtering. Search google for squid black list, and keep them adding 🙂

      Actually its a social issue, You have to create a Strict User Policy. Its the way to go.


      Comment by Syed Jahanzaib / Pinochio~:) — May 20, 2012 @ 8:23 PM

  2. good day, im wondering if u have any msn?? can u add me to ur msn?? my msn contact as my email.. thx!


    Comment by Lau — May 25, 2012 @ 9:36 AM

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: