Allocated Memory Alert on Server Matt 27.06.2007 09:00:02 Hi, I have a server with Small business server R2 2003 Premium Hardware Dell SC1430 2 x Xeon 5130 2.0GHz, 4 GB ram 3 x 146 gb SAS disks with Perc 5i U320 SAS Controller (Raid 5 config). I keep getting messages saying "A large amount of memory is committed to applications and processes etc" I then raised the default alert threshold from 2Gb to 3Gb and still got the messages. I investaged a little further and had a look in task manager and found that an instance of sqlservr.exe (MSSQL$MSFW) had memory usuage of 1,700,000 which seems a little high. Is this the instance for ISA 2004 and if it is what should I do (reinstall/ reconfiguire) ?? thanks matt

Re: Allocated Memory Alert on Server "Claus" <cjobes[ at ]nova-tech.org> 27.06.2007 13:10:25 This is a normal behavior. SQL will release the memory if other apps need it. -- Claus "Matt" <Matt[ at ]discussions.microsoft.com> wrote in message news:3ABFA1CA-6CB3-4581-B3B8-C9A63753B004[ at ]microsoft.com... [Quoted Text] > Hi, > > I have a server with Small business server R2 2003 Premium > Hardware Dell SC1430 2 x Xeon 5130 2.0GHz, 4 GB ram 3 x 146 gb SAS disks > with Perc 5i U320 SAS Controller (Raid 5 config). I keep getting messages > saying "A large amount of memory is committed to applications and > processes > etc" I then raised the default alert threshold from 2Gb to 3Gb and still > got > the messages. I investaged a little further and had a look in task manager > and found that an instance of sqlservr.exe (MSSQL$MSFW) had memory usuage > of > 1,700,000 which seems a little high. Is this the instance for ISA 2004 and > if > it is what should I do (reinstall/ reconfiguire) ?? > > thanks > matt

Re: Allocated Memory Alert on Server "Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]" <sbradcpa[ at ]pacbell.net> 27.06.2007 14:25:39 ISA doesn't need that much... stomp on it. google on allocated memory alert Claus wrote: [Quoted Text] > This is a normal behavior. SQL will release the memory if other apps need > it. >

Re: Allocated Memory Alert on Server "Claus" <cjobes[ at ]nova-tech.org> 27.06.2007 23:12:09 I love stomping :) -- Claus "Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]" <sbradcpa[ at ]pacbell.net> wrote in message news:eZ4UKcMuHHA.1184[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > ISA doesn't need that much... stomp on it. > > google on allocated memory alert > > Claus wrote: >> This is a normal behavior. SQL will release the memory if other apps need >> it. >>