[isapros] Re: MSDE Ram Rule of Thumb
- From: "Thor (Hammer of God)" <thor@xxxxxxxxxxxxxxx>
- To: "isapros@xxxxxxxxxxxxx" <isapros@xxxxxxxxxxxxx>, Thomas W Shinder <tshinder@xxxxxxxxxxx>
- Date: Mon, 22 May 2006 11:26:24 -0700
I hear it's around 2 minutes.
t
On 5/22/06 10:47 AM, "Thomas W Shinder" <tshinder@xxxxxxxxxxx> spoketh to
all:
> For how long?
>
> Thomas W Shinder, M.D.
> Site: www.isaserver.org
> Blog: http://blogs.isaserver.org/shinder/
> Book: http://tinyurl.com/3xqb7
> MVP -- ISA Firewalls
>
>
>
>> -----Original Message-----
>> From: isapros-bounce@xxxxxxxxxxxxx
>> [mailto:isapros-bounce@xxxxxxxxxxxxx] On Behalf Of Thor
>> (Hammer of God)
>> Sent: Monday, May 22, 2006 11:10 AM
>> To: isapros@xxxxxxxxxxxxx
>> Subject: [isapros] Re: MSDE Ram Rule of Thumb
>>
>> It's only "grab and hold" when installed on Greg's system.
>>
>> t
>>
>>
>> On 5/22/06 8:14 AM, "Thomas W Shinder" <tshinder@xxxxxxxxxxx>
>> spoketh to
>> all:
>>
>>> Hi Jim,
>>>
>>> But do you know if the MSDE instance will release memory to other
>>> processes that require it? Or is it a 'grab and hold' operation?
>>>
>>> Thomas W Shinder, M.D.
>>> Site: www.isaserver.org
>>> Blog: http://blogs.isaserver.org/shinder/
>>> Book: http://tinyurl.com/3xqb7
>>> MVP -- ISA Firewalls
>>>
>>>
>>>
>>>> -----Original Message-----
>>>> From: isapros-bounce@xxxxxxxxxxxxx
>>>> [mailto:isapros-bounce@xxxxxxxxxxxxx] On Behalf Of Jim Harrison
>>>> Sent: Monday, May 22, 2006 9:17 AM
>>>> To: isapros@xxxxxxxxxxxxx
>>>> Subject: [isapros] Re: MSDE Ram Rule of Thumb
>>>>
>>>> Yep - this has been "in the wild" for some time now.
>>>> What we don't have (and a reasonable request) is how to
>> correlate ISA
>>>> logging load with MSDE memory requirements.
>>>>
>>>>
>>>> -----Original Message-----
>>>> From: isapros-bounce@xxxxxxxxxxxxx
>>>> [mailto:isapros-bounce@xxxxxxxxxxxxx]
>>>> On Behalf Of Steve Moffat
>>>> Sent: Monday, May 22, 2006 7:02 AM
>>>> To: isapros@xxxxxxxxxxxxx
>>>> Subject: [isapros] Re: MSDE Ram Rule of Thumb
>>>>
>>>> I bow to your superior knowledge...J
>>>>
>>>>
>>>>
>>>> I came across this.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Well it turns out that the max server memory setting in
>> MSDE (and SQL)
>>>> defaults to 2147483647Mb!! A little more digging and I found a SQL
>>>> script to change this memory. Copy the following into
>> notepad and save
>>>> as sqlmemorylimit.sql .
>>>>
>>>> USE master
>>>> EXEC sp_configure 'show advanced options', 1
>>>> RECONFIGURE WITH OVERRIDE
>>>>
>>>> USE master
>>>> EXEC sp_configure 'max server memory (MB)', 64
>>>> RECONFIGURE WITH OVERRIDE
>>>>
>>>> USE master
>>>> EXEC sp_configure 'show advanced options', 0
>>>> RECONFIGURE WITH OVERRIDE
>>>>
>>>> With this SQL script saved we can now run it with the
>>>> following command.
>>>>
>>>> osql -E -S servername\MSFW -i c:\sqlmemorylimit.sql
>>>>
>>>> This will set the memory limit for MSDE to 64MB. Now you
>> are probably
>>>> thinking that 64MB is awefully low, and you are right. The box in
>>>> question only had 256MB ram, however I would suggest to set
>>>> this to 1/4
>>>> of the total amount of physical memory. As an example, if
>> you have 1GB
>>>> of memory, set this to 256MB.
>>>>
>>>> ________________________________
>>>>
>>>> From: isapros-bounce@xxxxxxxxxxxxx
>>>> [mailto:isapros-bounce@xxxxxxxxxxxxx]
>>>> On Behalf Of Thomas W Shinder
>>>> Sent: Monday, May 22, 2006 11:00 AM
>>>> To: isapros@xxxxxxxxxxxxx
>>>> Subject: [isapros] Re: MSDE Ram Rule of Thumb
>>>>
>>>>
>>>>
>>>> Hi Steve,
>>>>
>>>>
>>>>
>>>> There is a way to set a limit on the MSDE process, but I
>> didn't think
>>>> there was a requirement to do so. My impression is that
>> the SBS admins
>>>> think that MSDE is a runaway process because it does use available
>>>> memory, so it looks like it taking too much. But I think it
>>>> releases it
>>>> to other processes that require it. At least that's what I
>>>> understand at
>>>> this point. Maybe someone can prove it otherwise.
>>>>
>>>>
>>>>
>>>> Thomas W Shinder, M.D.
>>>> Site: www.isaserver.org <http://www.isaserver.org/>
>>>> Blog: http://blogs.isaserver.org/shinder/
>>>> Book: http://tinyurl.com/3xqb7
>>>> MVP -- ISA Firewalls
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ________________________________
>>>>
>>>> From: isapros-bounce@xxxxxxxxxxxxx
>>>> [mailto:isapros-bounce@xxxxxxxxxxxxx] On Behalf Of Steve Moffat
>>>> Sent: Monday, May 22, 2006 8:43 AM
>>>> To: isapros@xxxxxxxxxxxxx
>>>> Subject: [isapros] Re: MSDE Ram Rule of Thumb
>>>>
>>>> As far as I know, it will release RAM when another app / process
>>>> requires it. I don't think there is any way to modify the behavior.
>>>>
>>>>
>>>>
>>>> S
>>>>
>>>>
>>>>
>>>> ________________________________
>>>>
>>>> From: isapros-bounce@xxxxxxxxxxxxx
>>>> [mailto:isapros-bounce@xxxxxxxxxxxxx] On Behalf Of Amy Babinchak
>>>> Sent: Sunday, May 21, 2006 8:57 PM
>>>> To: isapros@xxxxxxxxxxxxx
>>>> Subject: [isapros] MSDE Ram Rule of Thumb
>>>>
>>>>
>>>>
>>>> In the SBS world when we switch to MSDE logging in ISA, the MSDE
>>>> service can end up taking all available ram unless we go in
>>>> and tell it
>>>> otherwise. Is there a rule of thumb for setting the ram on the MSDE
>>>> instance for ISA? Something like X requests per minute = X mb ram?
>>>>
>>>>
>>>>
>>>> thanks,
>>>>
>>>>
>>>>
>>>> Amy
>>>>
>>>>
>>>> All mail to and from this domain is GFI-scanned.
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>
>
>
Other related posts:
