Post reply

sql not use more then 1.7GB mem

  • February 20, 2009 at 2:31 am

    #134926

    Hi,

    I've Windows Server 2003 ENT(32BIT) and SQL Server 2005 STD SP2 (32BIT).my server have 8GB mem total.

    i set the PAE in the boot.ini enable the AWE in the SQL and set min mem to 3GB and max mem to 6GB,i set the lock pages in memory to the sql service start user.

    but my sql server not use more then 1.7GB.

    i monitor the Target server memory and total server memory and it show 1.7GB on both monitor.

    did i miss something in my configuration that my sql can't use more then 1.7GB?

    THX

  • February 20, 2009 at 2:50 am

    #947376

    Could be that SQL doesn't need more than 1.7 GB. In 2005 SQL won't allocate the min memory when it starts up. That's a value that once reached the memory usage will not drop below.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 20, 2009 at 3:05 am

    #947379

    i'm pretty sure that this sql needs more then 1.7GB,

    beacuse i've more then 100 users connected to this instance with more then 25 DB's on it,and the TRN log that backup evey hour are very big(3-5GB),that's why i think that the server needs more then 1.7GB.

    any idea on my configuration?

    THX

  • February 20, 2009 at 3:14 am

    #947385

    Config looks fine. Have you rebooted since adding the boot.ini switch?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 20, 2009 at 3:18 am

    #947387

    yes twice.

    can SQL Server 2005 STD 32BIT on Windows Server 2003 ENT 32BIT work with more then 2-3GB mem(the 32bit mem limit)?

    THX

  • February 20, 2009 at 7:31 am

    #947495

    Mad-Dog (2/20/2009)

    can SQL Server 2005 STD 32BIT on Windows Server 2003 ENT 32BIT work with more then 2-3GB mem(the 32bit mem limit)?

    Yes.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 20, 2009 at 8:06 am

    #947531

    Hi,

    Have you looked into enabling AWE, I think this is the only way to address more memory, might be worth telling us what your total/target server memory is from perfmon.

  • February 20, 2009 at 8:45 am

    #947572

    as i mentioned in my first post - the perfmon show me in both total and target server 1.7GB.

  • February 20, 2009 at 9:04 am

    #947592

    sp_configure

    did you enable AWE here ?

  • February 20, 2009 at 9:07 am

    #947593

    Can you show us the boot.ini file?

  • February 20, 2009 at 7:25 pm

    #948068

    Have you granted lock pages in memory privilege to sql service account? Was sql restarted after enabling AWE?

    MJ

  • February 21, 2009 at 12:20 am

    #948114

    the sql was restart twice after that i enable the AWE and PAE in the boot.ini

    when i query the sys.configuration i see that the value = 1 but the value_in_use = 0

    so i restart the sql server service and now the value_in_use = 1 and when i look at perfmon the Target Server Memory looks good (6GB).

    i don't know why after restart the server twice the configuration not apply,but when i'll have a window i'll restart the server to see his behavior.

    THX

Viewing 12 posts - 1 through 11 (of 11 total)

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