recommended amount of RAM and tuning parameters?

  • I have a 32 bit Windows 2003 Server Enterprise Edition Server with one quad core processor 2.83ghz and the box has 3.25 GB of RAM.

    Is this adequate to run one default and two Named Instances of SQL Server 2005 Standard Edition (patched to SP3) ??

    If so, are there any tuning parameters I should be aware of?

  • No, your memory is WOEFULLY inadequate. double your memory and cou count and we can talk.. I can see you having problems with processor, memory, and probably disk contention. You might get one ok server out of that, but absolutely not three.

    CEWII

  • With the additional Memory, what kind of parameters would have to be changed or what kind of tuning would ahve to take place in order to take advantage of the additional memory?

  • Jpotucek (10/7/2009)


    With the additional Memory, what kind of parameters would have to be changed or what kind of tuning would ahve to take place in order to take advantage of the additional memory?

    Such an open ended question, you have to take into account the workload that each individual instance will be responsible for, for a start.

    it would be better if you could describe what each instance would be used for, the specification you have now, is suitable for a single instance. you can change memory settings once you have bought more. Do you know how much extra ram you will be adding ot this box.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • You'll be able to run three instances of SQL Server on this system, certainly. The question is, what will they be doing? How much data are you storing, how many users making how many connections, how many queries moving what kind of data? It really depends on all this to say that a given configuration is adequate. Without a baseline measure of the databases running on each given instance, it's impossible to say that this server will support three different instances.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply