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??
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?
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?
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.
> 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!
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 firstname.lastname@example.org and I'll get you set up and provide you some details.
Hi guys, Many thanks for the links.. By the way i have decided to leave ISA Server free to have so much memory because:
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.
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.