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

x
  • 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.
0
paulfryer
Asked:
paulfryer
1 Solution
 
Jokra_the_BarbarianCommented:
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.
0
 
cjinsocal581Commented:
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:

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

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
0
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.
0
 
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.
0
 
solution46Commented:
Got to agree here. You've got a fairly heavily used system - go buy a separate web server.

s46.
0

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