sql server is not using more than 3gb causing performace issues.

  • sql server is not using more than 3gb causing performace issues.

    total ram is 8gb

    windows 2003 32 bit

    sql 2005 sp3 32 bit

    awe enabled,lock pages enabled.

    sql using 3gb ram only.

    i want to sql to be use 6gb.

    any other setting do i need to change?any help?

  • 1. Enable PAE (Physical Address Extension) at the OS level .

    2. Enable AWE and Set Max Memory = 6 GB

    3. Use Lock Pages in Memory

    Thank You,

    Best Regards,

    SQLBuddy

  • i did everything.any help?

  • What edition of SQL Server 2005 are you running and are you running on a physical or virtual server?

  • you made the suggested changes as indicated by SQLBuddy and still experience the issue??

  • i did all changes,sql2005Enterprise sp3

  • Are you running Windows Standard or Enterprise Edition? If you are running Windows Standard Edition, you will not be able to access 6 GB of memory.

    From SQL Server 2005 Books Online:

    http://msdn.microsoft.com/en-us/library/ms190673(v=SQL.90).aspx"

    Enabling AWE Memory for SQL Server

    ...

    The physical memory accessible by AWE depends on which operating system you are using. The following list provides the maximum physical memory accessible by each Windows Server 2003 operating system at the time of writing.

    Windows Server 2003, Standard Edition supports physical memory up to 4 GB.

    Windows Server 2003, Enterprise Edition supports physical memory up to 32 GB.

    Windows Server 2003, Datacenter Edition supports physical memory up to 64 GB."

  • select * from sys.dm_os_performance_counters

    where counter_name = 'Page life expectancy'

    provide value of this counter,RAM allocation is depend on the load of the server,this counter will tell you SQL Server required RAM or not

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • winfowd 2003r2 32 bit enterprise sp2

    sql2005 32bit enterprise sp3

    object _name cntr_value cntr_type

    buffermanager 732 65792

    buffer node 732 65792

  • Did you restart SQL Server after setting lock pages in memory?

    How large is the database actual space used in the data files?

  • i did restart

  • We have covered the simple things that can be covered on a forum thread. I recommend you get a professional tuner to remote into your system and do a quick review to find out the source of your problem.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • i did,around 300 GB

  • Is the problem resolved ? Could you provide us an update ?

    Thank You,

    Best Regards,

    SQLBuddy

Viewing 15 posts - 1 through 15 (of 19 total)

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