SQL Server Performance

Use of memory on a 4GB server

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by laserovic, Jun 23, 2007.

  1. laserovic New Member

    Hello,

    I have 4-CPU server with 4GB memory. It is dedicated SQL server. Currently I have Windows 2003 standard edition and SQL 2005 standard edition. It used only about 1,7 GB for the SQL server and 300 MB for other processes (system processes) , task manager showed 2,0 GB of use.
    Then I added /3GB switch to boot.ini. After that, system shows use of about 3GB, but SQL stayed on 1,7 GB max (even I set more in properties), the only advantages was, that I could use another 1,3 GB for other applications.
    But I would like to give more memory to SQL server. I searched web, but I am still not sure about if it is
    -possible on current software or if not,
    -what are possibilities how to do that (upgrade to Windows Enterprise is of course much cheaper even with some memory addition, than to buy SQL 2005 Enterprise, will AWE memory help me?)

    P.S. I can use only 32-bit software.
  2. MohammedU New Member

    Check the following article...
    http://support.microsoft.com/kb/274750

    Make sure you change the "max server memory (MB)" setting and restarted sql services...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. laserovic New Member

    quote:Originally posted by MohammedU

    Check the following article...
    http://support.microsoft.com/kb/274750

    Make sure you change the "max server memory (MB)" setting and restarted sql services...

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    of course i did. See picture1 and pic2 and pic3
    But the article from MS is too old and doesn' deal with SQL 2005.
  4. satya Moderator

    I don't think so, refer the text under that KBA:

    quote:If you are using SQL Server 2005 to configure memory to use more than 2 GB of physical, see the following topics in SQL Server 2005 Books Online:• Memory Architecture
    • Server Memory Options
    • Using AWE
    • Enabling Memory Support for Over 4 Gb of Physical Memory
    • Enabling AWE Memory for SQL Server

    APPLIES TO
    • Microsoft SQL Server 2000 Enterprise Edition
    • Microsoft SQL Server 7.0 Standard Edition
    • Microsoft SQL Server 2005 Enterprise Edition


    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  5. MohammedU New Member

    Do not rely on Task Manager...

    Use perfmon counters TOTAL SERVER MEMORY and TARGET SERVER MEMORY to check the memory...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page