How much ram should I have installed on a Windows 2000 server that acts as a web server and database server running SQL Server 2000 standard? We currently have 1 Gig or RAM. We expect the load to increase to over 2 Million page views a week. Are there general guidelines for SQL Server and the amount of RAM needed? It would be great if there was a formula to determine the optimal amount of RAM to install.