Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

How Much RAM should I install for SQL Server?

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.
1 Solution
Hmmm, no real formula that I'm aware of because it depends on the application and data. Normal, it's best to separate your db from your web box. If you had a database server, then I would say a dual processor with 1 Gig RAM and a single processor web server with 512 MB RAM would be a good starting point. You can alway upgrade the RAM if you need more. Having the db on its own box is also more secure.
also make sure to set the Memory usage to a set amount instead of dynamic. We have found that SQL will sometimes take more memory that is in the system.

SQL server properties:

Used a fixed memory size (MB): set it to 512.
Eugene ZCommented:
More memory it is good..
but see limitations for for sql server2k standard edition :
Maximum Capacity Specifications

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Scott PletcherSenior DBACommented:
I suggest you get at least 3G.  SQL can use 2G and Windows and web server and whatever can use the other gig.  You will see a big performance hit if you reduce SQL's memory too low and/or allow SQL to constantly get and release memory.
Anthony PerkinsCommented:
>>We expect the load to increase to over 2 Million page views a week. <<
As suggested previously and with this many hits, do yourself a favor and split the boxes up.  SQL Server runds best standalone.
Got to agree here. You've got a fairly heavily used system - go buy a separate web server.


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now