Insufficent Virtual Memory errors
Posted on 2005-03-17
We have a Windows 2000 server with 6 GB of RAM functioning solely as a SQL server for a Sharepoint Portal (2003). As the number of users of the Sharepoint site rose over 500, we began to get insufficient virtual memory errors. I find this hard to believe with 6GB of physical RAM at the system's disposal. The total number of users for the Sharepoint site is now at about 900, but only about 50 to 75 percent of those actively use the site. The pagefile was only set to 2 GB, but still, with 6 GB of physical RAM, that shouldn't be much of an issue, should it? I've upped the pagefile size by 3 GB and placed the extra on a second drive. We are beginning to get similar errors on the Sharepoint server itself, but it only has 2GB of physical RAM and a 2GB pagefile. I plan on increasing that to 3 GB and spreading it across the system's two logical drives. Is there anything else I should do or can check especially on the SQL server?