Allocated Memory Alert Revisited

T.Sean’s Introspection » Blog Archive » sqlserver.exe eating memory

T.Sean’s Introspection » Blog Archive » sqlserver.exe eating memory — Wed, 16 Jan 2008 09:43:13 GMT

Pingback from T.Sean’s Introspection » Blog Archive » sqlserver.exe eating memory

You don't put applications that suck on a SBS box

E-Bitz - SBS MVP the Official Blog of the SBS "Diva" — Thu, 07 Jun 2007 01:57:24 GMT

Small Biz Thoughts by Karl Palachuk: Overloading SBS: http://smallbizthoughts.blogspot.com/2007/06/overloading

Rebooting a SBS box gives me just enough time to visit to the ladies room actually...

E-Bitz - SBS MVP the Official Blog of the SBS "Diva" — Fri, 01 Jun 2007 07:14:42 GMT

Now in honesty there are times that I will get frustrated with my server...but lately it's been due

Rebooting a SBS box gives me just enough time to visit to the ladies room actually...

E-Bitz - SBS MVP the Official Blog of the SBS "Diva" — Fri, 01 Jun 2007 07:12:42 GMT

Now in honesty there are times that I will get frustrated with my server...but lately it's been due

WSUS 3.0 Is Still A Memory Hog

Jesper's Blog — Mon, 07 May 2007 06:14:29 GMT

This evening I brought my WSUS server up to WSUS 3.0. Mostly I wanted to see if it still was as big a

fuzzis log » vmware hints

fuzzis log » vmware hints — Thu, 28 Dec 2006 08:51:19 GMT

PingBack from http://blog.werdeichgefunden.com/?p=10

re: Allocated Memory Alert Revisited

Brandon — Mon, 30 Oct 2006 18:56:51 GMT

I followed this on a SBS 2003 server which was running high on SBSMONITORING. After a month, the error came back, and I re-ran. So far it's running a lot less, something like 90MB. Has anyone seen it come back like I have? Any ideas or suggestions?

re: Allocated Memory Alert Revisited

Henry Tjham — Thu, 07 Sep 2006 16:25:34 GMT

Had this exact problem last month with SBSMONITORING, did everything suggested, problem solved. Thanks SBS Diva. Yesterday, got the same Allocated Memory Alert again, this time caused by WSUS (PID points to MSSQL$WSUS). I used the same commands to set the maximum memory to 70 MB. Simply replace SBSMONITORING with WSUS in the commands. Then I tested WSUS's queries on Updates, Computers, and Reports. Everything ran fine and just as fast. ------------------------------------------ Extra info: You can check the maximum memory allocation for your processes by using the SQL commands provided in the following KB: http://support.microsoft.com/kb/909636. The KB also gives you the SQL commands that sets the maximum limit, it does exactly the same thing as the CMD commands provided by SBS Diva. ------------------------------------------ Keywords (to help searches to point here): WSUS Allocated Memory Alert WSUS MSSQL$WSUS

re: Allocated Memory Alert Revisited

Phil Gillespie — Mon, 04 Sep 2006 12:46:04 GMT

Have applied this to over 20 servers now and works well. The MSFW also seems to run away with memory and seems to work on this also.

re: Allocated Memory Alert Revisited

Online Pharmacy — Wed, 30 Aug 2006 11:17:58 GMT

Quiet cool , but

Please post a list over the mem values if you get them (I tried 70 and this seems to work fine for me too).

re: Allocated Memory Alert Revisited

Marco — Fri, 25 Aug 2006 01:02:41 GMT

Try it with a capital -E -S

re: Allocated Memory Alert Revisited

Daryl Sensenig — Wed, 23 Aug 2006 12:52:26 GMT

Thanks, this looks like a great solution. However, when I type "osql -e -s SERVERNAME\sbsmonitoring" I get this: "Error: No user selected. Try -u or -e switches"
Any suggestions?

re: Allocated Memory Alert Revisited

Kjetil — Mon, 24 Jul 2006 08:44:47 GMT

Brilliant! Thanx a lot!

Please post a list over the mem values if you get them (I tried 70 and this seems to work fine for me too).

Best regards
Kjetil

re: Allocated Memory Alert Revisited

Cary Hetzel — Wed, 19 Jul 2006 20:08:46 GMT

Wow! Thank You so very much!! After following the instructions our sqlservr.exe went from 775,460 K to 111,556 K!!

That's like 1/7 of what it was!! No wonder our server was starting to lag a bit!!

Is there anything that can help with the store.exe?? I know this is eats quite a bit of memory as well.

Also, since this is now eating much less RAM, will this effect SQL's performance?? Right now we aren't really using it, but we have a new ERP that runs on .NET and uses SQL, will this negatively affect how our ERP runs?? Or... will the system adjust to meet the needs?

If it's really bad, and negatively affects our ERP, how can I switch it back?

re: Allocated Memory Alert Revisited

Jeff Stillwell — Mon, 10 Jul 2006 15:02:32 GMT

Thanks for posting this solution! It seems to be the trick for 2 of our clients who are using ML350's with dual Xeon procs and 4gb RAM!

Jeff

re: Allocated Memory Alert Revisited

Fionnbarr Kennedy — Tue, 27 Jun 2006 12:58:47 GMT

I'm just a bloke who has to run his network while doing the day job. Tried this after much troubleshooting - I guess its something should be pre-configured in SBS 2003 - there must be lots of people wondering why their server's running slow! Thanks v much for the suggestion!

Looking at some SQL/MSDE/WMSDE log files

TrackBack — Sat, 06 Aug 2005 22:20:00 GMT

ISA 2004 sucking up a bit too much memory in SBS 2003?

TrackBack — Tue, 14 Jun 2005 04:05:00 GMT

Do we truly want to be secure? I don't think we truly do.

TrackBack — Tue, 22 Mar 2005 02:53:00 GMT

Allocated Memory Alert - part deux

TrackBack — Tue, 08 Mar 2005 01:03:00 GMT