So what would you recommend when you have 8 instances on one NT server
(768MB).
--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.
Marcus N Hofer wrote in message ...
>if just the DB server, the TNS listener and nothing (remarkable) else
>is running on the NT server, donīt hesitate and give 2/3 of the memory
>to the SGA if the memory as such is bigger than 128 MB!
>
>I increased the SGA at a customers NT server(512MB) with heavy query
>load from 1/2 to 2/3 of physical memory and retrieved a pretty good
>performance increase.
>
>regards,
>--marcus
>
>
>skubiszewski_at_Eisner.DECUS.Org schrieb in Nachricht ...
>>It seems to be common to size the SGA at 1/3rd of physical memory
>>but is this true for Windows NT?
>>
>>What would you recommend as a "rule of thumb" for setting
>>the SGA on an NT box?
>>
>>Thanks,
>>
>>Rose
>
>
Received on Tue Feb 09 1999 - 13:28:08 CST
