Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Virtual Memory

Author  Topic 

gds_78
Starting Member

6 Posts

Posted - 2004-03-01 : 03:26:06

I'm a newbie. If I have 1.5GB of RAM for my SQL server, how much should I allocate for my virtual memory? Is there any formula ?


Thanks in advance

gds that smiles

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-01 : 13:17:02
For the page file, you should allocate at least 1.5GB (at least one times the amount of RAM). Also, the page file should be located on an array where the OS is not installed.

Tara
Go to Top of Page
   

- Advertisement -