• RSS
  • Twitter
  • FaceBook

Welcome to ISAserver.org

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

MEMORY ALLOCATION FOR MSDE

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> MEMORY ALLOCATION FOR MSDE Page: [1]
Login
Message << Older Topic   Newer Topic >>
MEMORY ALLOCATION FOR MSDE - 6.Dec.2005 3:50:28 PM   
jogreg

 

Posts: 9
Joined: 28.Oct.2005
From: orlando
Status: offline
Currently the MSDE process is taking up 1.5 GB of RAM, I checked the allocated memory and is set to the default (2147483647).  
What is the recommended amount of memory that should be allocated for MSDE?
In the next few months there will be about 1000 users going through the ISA server. It's only used as a Proxy Server.
Would it make a big difference if a change the web proxy logging to W3c format instead of MSDE??

Thanks in advance 
Post #: 1
RE: MEMORY ALLOCATION FOR MSDE - 3.Jan.2006 4:29:45 PM   
tshinder

 

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline
Hi Jo,

Check out:

http://support.microsoft.com/default.aspx?scid=kb;en-us;325003

HTH,
Tom

_____________________________

Thomas W Shinder, M.D.

(in reply to jogreg)
Post #: 2
RE: MEMORY ALLOCATION FOR MSDE - 4.Jan.2006 7:47:44 AM   
Covani

 

Posts: 10
Joined: 22.Sep.2005
From: Istanbul
Status: offline
Hi, the same here.. Use SQL Server 2000 and ISA 2004 Enterprise on same server.
Currently 1.5 GB ram resource only for mssql process, although I have disabled SQL server from services. It runs only the mssql$ for ISA..
any suggestions?

(in reply to tshinder)
Post #: 3
RE: MEMORY ALLOCATION FOR MSDE - 4.Jan.2006 3:09:39 PM   
LLigetfa

 

Posts: 2187
Joined: 10.Aug.2004
From: fort frances.on.ca
Status: offline
Do you mean any OTHER suggestions?  What is wrong with the link Tom posted?

_____________________________

The School of Hard Knocks is a mean teacher. She gives the exam before the lesson.

(in reply to Covani)
Post #: 4
RE: MEMORY ALLOCATION FOR MSDE - 5.Jan.2006 3:31:42 AM   
tshinder

 

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline
Hi Les,

Thanks for that. I thought I was seeing things and my post actually wasnt' there :)

Tom

_____________________________

Thomas W Shinder, M.D.

(in reply to LLigetfa)
Post #: 5
RE: MEMORY ALLOCATION FOR MSDE - 5.Jan.2006 3:41:36 AM   
tshinder

 

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline
Maybe this one will work better:

http://support.microsoft.com/default.aspx?scid=kb;en-us;909636&sd=rss&spid=2108

HTH,
Tom

_____________________________

Thomas W Shinder, M.D.

(in reply to tshinder)
Post #: 6
RE: MEMORY ALLOCATION FOR MSDE - 5.Jan.2006 4:55:11 AM   
LLigetfa

 

Posts: 2187
Joined: 10.Aug.2004
From: fort frances.on.ca
Status: offline
Well... if those two links are not enough, one could always use the board search on something as simple as memory msde and get all the threads that have discussed this time and time again.

http://forums.isaserver.org/searchpro.aspx?phrase=msde+memory&author=&forumid=ALL&topicreply=both&message=body&timeframe=%3E&timefilter=0&language=single&top=300&criteria=AND&submitbutton=+OK+

_____________________________

The School of Hard Knocks is a mean teacher. She gives the exam before the lesson.

(in reply to tshinder)
Post #: 7
RE: MEMORY ALLOCATION FOR MSDE - 5.Jan.2006 6:26:25 PM   
tshinder

 

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline


_____________________________

Thomas W Shinder, M.D.

(in reply to LLigetfa)
Post #: 8
RE: MEMORY ALLOCATION FOR MSDE - 6.Jan.2006 4:10:31 PM   
pruittwh

 

Posts: 16
Joined: 15.Feb.2005
Status: offline
I had the same problem.  MSSQL$MSFW was causing memory threshold alerts (monitoring via NetIQ).  I changed the logging method to W3C file format in an effort to stop ISA from using MSDE.  Admitting my ignorance, is the MSSQL@MSFW service necessary if I'm not logging to an MSDE database?  Microsoft Firewall and SQLAgent$MSFW are both shown as dependencies on this service.  Can I disable the service?  or will it cause the Firewall not to start?  I was guessing that since I'm not logging to an MSDE database, I could solve the memory issue without limiting the amount of memory that the service hogs.  Thoughts?  Comments?

Thanks,
William

(in reply to tshinder)
Post #: 9
RE: MEMORY ALLOCATION FOR MSDE - 6.Jan.2006 4:39:33 PM   
tshinder

 

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline
Hi William,

You can remove the SQL logging service by rerunning setup from the Add/Remove Programs applet and removing the Advanced Logging feature.

HTH,
Tom

_____________________________

Thomas W Shinder, M.D.

(in reply to pruittwh)
Post #: 10
RE: MEMORY ALLOCATION FOR MSDE - 8.Jan.2006 4:30:45 AM   
J.F.

 

Posts: 43
Joined: 28.Nov.2005
Status: offline
Hello:

If you want an easier way to display/edit the amount of memory MSDE can use, get the script named "ISA_MSDE_Max_Memory.vbs" from www.ISAscripts.org.  It doesn't require OSQL.EXE and has just a couple simple command-line switches.

  Cheers,
     JF

(in reply to tshinder)
Post #: 11
RE: MEMORY ALLOCATION FOR MSDE - 8.Jan.2006 3:54:15 PM   
tshinder

 

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline
Hi Jason,

Thanks! Great link!

BTW -- you have a great site! Come back more often

Tom

< Message edited by tshinder -- 8.Jan.2006 3:55:26 PM >


_____________________________

Thomas W Shinder, M.D.

(in reply to J.F.)
Post #: 12
RE: MEMORY ALLOCATION FOR MSDE - 9.Jan.2006 12:39:27 AM   
J.F.

 

Posts: 43
Joined: 28.Nov.2005
Status: offline
> BTW -- you have a great site! Come back more often

Thank you!  I've been meaning to drop you a line to say Hello and to say thanks for posting a link to my site in your Links area, but the end of 2005 was *really* busy for me and I just got engaged too     The beginning of the year is always slow for my work, though, so I should have more free time to browse the forums and newsgroups that I like, and your site is the best for ISA of course!

   Cheers!
      JF

(in reply to tshinder)
Post #: 13
RE: MEMORY ALLOCATION FOR MSDE - 9.Jan.2006 7:13:46 PM   
tshinder

 

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline
Hi Jason,

Thanks for the kind words about the site. We'll create a virtual mutual admiration society :)

I'd be glad to mention your classes/consultation offerings in next month's newsletter. Let me know what you want folks to know.

If you can post on the message boards that would be great! If you want to write some articles and be part of your author's group, send me a note at tshinder@tacteam.net and I'll get you set up and provide you some details.

Thanks!
Tom

_____________________________

Thomas W Shinder, M.D.

(in reply to J.F.)
Post #: 14
RE: MEMORY ALLOCATION FOR MSDE - 17.Jan.2006 8:43:17 AM   
Covani

 

Posts: 10
Joined: 22.Sep.2005
From: Istanbul
Status: offline
Hi guys,
Many thanks for the links..
By the way i have decided to leave ISA Server free to have so much memory because:

quote:


CAUSE
Microsoft SQL Server uses the available physical memory to optimize MSDE insertion and query processes. SQL Server is designed to release physical memory as soon as there is a request for physical memory from other processes that are running on the computer.

(in reply to tshinder)
Post #: 15
RE: MEMORY ALLOCATION FOR MSDE - 17.Jan.2006 4:00:01 PM   
tshinder

 

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline
Hi Covani,

Yes, that's why I don't change it. I think most people want to change it because they're not aware of this.

Thanks!
Tom

_____________________________

Thomas W Shinder, M.D.

(in reply to Covani)
Post #: 16
RE: MEMORY ALLOCATION FOR MSDE - 17.Jan.2006 6:54:42 PM   
LLigetfa

 

Posts: 2187
Joined: 10.Aug.2004
From: fort frances.on.ca
Status: offline
While this may be considereed scope creep, I capped my MSDE because I was having problems trying to allocate RAM cache.
http://forums.isaserver.org/m_340014500/mpage_1/key_ram%2ccache/tm.htm#340014500
I never did get a clear answer on the board and I cannot remember the details of what I tried.  I don't recall now whether MSDE trumps RAM cache.

_____________________________

The School of Hard Knocks is a mean teacher. She gives the exam before the lesson.

(in reply to tshinder)
Post #: 17
RE: MEMORY ALLOCATION FOR MSDE - 17.Jan.2006 6:59:41 PM   
LLigetfa

 

Posts: 2187
Joined: 10.Aug.2004
From: fort frances.on.ca
Status: offline
quote:

ORIGINAL: tshinder
Yes, that's why I don't change it...

Since you fessed up to running with only 256MB in another thread, I have to wonder how MSDE can even run.
http://forums.isaserver.org/m_2002003649/mpage_1/key_/tm.htm#2002003649

_____________________________

The School of Hard Knocks is a mean teacher. She gives the exam before the lesson.

(in reply to tshinder)
Post #: 18
RE: MEMORY ALLOCATION FOR MSDE - 19.Jan.2006 6:31:38 AM   
tshinder

 

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline
Hi Les,

Runs great. I almost never see my MSDE process run higher than 60MB. I don't know why it *seems* to go haywire on some boxes. I've never seen any of those boxes in person, so I haven't had a chance to troubleshoot the issue.

Tom

_____________________________

Thomas W Shinder, M.D.

(in reply to LLigetfa)
Post #: 19

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> MEMORY ALLOCATION FOR MSDE Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts