how to set virtual memory size after adding RAM to the server?

[Ales Baranek]

Hi,
I have a server with Windows 2000 server and Exchange 2000 and SQL 2000
server instaled on it. I have increased amount of physical RAM from 1GB to
3GB.
Initial size of virtual memory is now 1536 MB, max.size is 3072MB (I think
it was setting during installation of server) and recommended size is 4606
MB.
Can I set new virtual memory size to recommended. How is the max. size of
virtual
memory file in Windows 2000 server? What can I do to optimize memory?

 

[George Hester]

You have a number of questions in here some of which are outside the main. Let's look at the virtual memory first. Or what is really called pagefile.sys which lies on the root of the drive you have your operating system installed in.

pagefile.sys size depend only on your installed (physical) RAM. You can change it manually but the default is 1.5 times the amount of your RAM. This is assuming there is contiguous space for the file. If there is not then it will be the size of the contiguous space that allows the closest to 1.5 times your installed RAM. You can use more then one pagefile.sys. Right-click My Computer | Properties | Advanced | Performance Options... | Change... | take it from there.

Lastly what can you do to optimize memory. SQL 2000 has its own interface for that. Exchange 2000 may but I don't believe so. Optimzing memory is a function of the applications that you are using not the Operating system. Other then having sufficient contiguous space for the pagefile.sys you have done all you can do. Other than defragging the memory. Here is a short vbs file that will do this for you:

'memory.vbs
MyString = Space(128000000)

That's it. In the command prompt cscript memory.vbs

 

[Ales Baranek]

And how is the max size of pagefile.sys in windows 2000 server?

You have a number of questions in here some of which are outside the main.
Let's look at the virtual memory first. Or what is really called
pagefile.sys which lies on the root of the drive you have your operating
system installed in.

pagefile.sys size depend only on your installed (physical) RAM. You can
change it manually but the default is 1.5 times the amount of your RAM.
This is assuming there is contiguous space for the file. If there is not
then it will be the size of the contiguous space that allows the closest to
1.5 times your installed RAM. You can use more then one pagefile.sys.
Right-click My Computer | Properties | Advanced | Performance Options... |
Change... | take it from there.

Lastly what can you do to optimize memory. SQL 2000 has its own interface
for that. Exchange 2000 may but I don't believe so. Optimzing memory is a
function of the applications that you are using not the Operating system.
Other then having sufficient contiguous space for the pagefile.sys you have
done all you can do. Other than defragging the memory. Here is a short vbs
file that will do this for you:

'memory.vbs
MyString = Space(128000000)

That's it. In the command prompt cscript memory.vbs

 

[Bob I]

4 gig max per paging file and and as many paging files as your harddrive
has space for.