How Much RAM should I install for SQL Server?

Posted on 2005-04-08
Last Modified: 2006-11-18
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.
Question by:paulfryer
    LVL 11

    Expert Comment

    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.
    LVL 6

    Expert Comment

    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.
    LVL 42

    Expert Comment

    More memory it is good..
    but see limitations for for sql server2k standard edition :
    Maximum Capacity Specifications
    LVL 68

    Accepted Solution

    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.
    LVL 75

    Expert Comment

    by:Anthony Perkins
    >>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.
    LVL 9

    Expert Comment

    Got to agree here. You've got a fairly heavily used system - go buy a separate web server.


    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now