Joe wrote:
>Quick question. After setting lock pages in memory.
>
>Should we set the min and max memory.
>
>Or
>Do nothing
>
>Or?
>
>
>
>Thanks for any info.

"Joe" <Joe@discussions.microsoft.com> wrote in message
news:48A077F4-4A82-4603-9F28-329DB74050D7@microsoft.com...
> In this situation I was thinking of setting max memory to say 30 GB. If
> there was memory prssure due to a failover, I am under the impression that
> SQL 2005 would release back to the OS and the OS would release to the
> failed
> over instance of SQL server 2005.
>
> "Krisnamourt via SQLMonster.com" wrote:
>
>> Be careful!
>>
>> Its not clear all sp_configure and baseline at all.
>>
>> This two article show some problems to 64 bit:
>> http://support.microsoft.com/kb/918483/en-us
>>
>> http://support.microsoft.com/kb/931279/en-us
>>
>> Another question is:
>>
>> If you have 4 node with 32GB, 3 instances, so the normal is one instance
>> to
>> one node separated, but when happned failover cluster? I mean, one node
>> could
>> stay with 3 instances, so the memory could be shared!
>>
>> The best configuration is equal memory configuration or you can configure
>> to
>> max(32GB) ,but trigger some procedure to change sp_configure min and max
>> memory to another issue when happned failover.
>>
>> Joe wrote:
>> >Quick question. After setting lock pages in memory.
>> >
>> >Should we set the min and max memory.
>> >
>> >Or
>> >Do nothing
>> >
>> >Or?
>> >
>> >
>> >
>> >Thanks for any info.
>>
>> --
>> Message posted via http://www.sqlmonster.com
>>
>>