Re: NT/ORACLE/RAID and Performance PAIN

Ross,

The extract from http://www.ntfaq.com reads as follows

Q. How can I control the amount of memory NT uses for file caching?

1. Windows NT does not allow much tuning of caching except for one registry entry.

  1.Start the registry editor (regedit.exe)   2.Move to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ Session Manager\Memory

    Management
  3.Double click on LargeSystemCache and set to 0 to reduce the amount of memory used for file caching.
  4.Click OK
  5.Close the registry editor

If you start the Network control panel applet and select the Services tab you can select Server and click
Properties. Select "Maximize Throughput for Network Applications" to use less memory (this actually sets
LargeSystemCache to 0).

Chris
Piotr Kolodziej wrote:
>
> Ross Mohan wrote in message <7aa4pa$et8$1_at_paxfeed.eni.net>...
> >|| I am building tspaces and running import. ( yes, without indexes and
> >constraints in place)
>
> You mean performance problem while importing ?
> Hmm... In fact, there may be a serious problem with cache manager.
> Even if 'Maximize performance for Network Apps' is set, Cache Manager
> tends to steal memory from apps to satisfy large number of disk requests
> (especially while importing).
> Try using cacheset tool from www.sysinternals.com but sometimes NT ignores
> set cache size limitation (!).
>
> HTH,
> --
> Piotr Kolodziej pkol_at_otago.gda.pl
> Just my private opinion.
Received on Tue Feb 16 1999 - 16:12:16 CST