Post reply

sqlservr.exe utilizes very less memory comparitively as it did before a week

  • July 26, 2012 at 6:15 am

    #264270

    My production DB's got a maximum of 300 GB in size and it has users more than 300... Operates in windows server 2003 Enterprise edition 32 bit with ram of 32 GB. sqlservr.exe utilized around 28 GB before a week and suddenly it dropped to less than 2 GB of utilization and the performance of the site also completely dropped. Requests from the users remain the same but the utilization of sqlservr.exe memory doesnt creep up at all.

    I have checked for the Max Server memory and it retains its default value, AWE not enabled , Lock pages not Enabled..... I am running out of options and completely worried. Happily welcoming any suggestions......

    Thanks,

    Sathish.G Newbie

  • July 26, 2012 at 6:24 am

    #1517882

    Do you have the /PAE switch in the boot.ini file? If not it needs adding in.

    You will need to enable AWE and set lock pages in memory as its 32bit and your trying to address more than 4GB of RAM.

  • July 26, 2012 at 6:40 am

    #1517893

    Really thanks for the PAE topic. I will try this out and post it as soon as possible. But wats positive in enabling lock pages for a service increasing its memory utilisation.

    But I am still confused why did it drop suddenly.....

    Thanks,

    Sathish.G

  • July 26, 2012 at 6:45 am

    #1517896

    Because someone turned AWE off.

    The only way that a 32 bit instance could use 28GB of memory is if it had AWE enabled. So if it was using 28 GB last week, it had AWE enabled last week.

    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

  • July 27, 2012 at 1:52 am

    #1518326

    Well.... I have enabled the PAE switch and AWE for the production instance in the server.... waiting for the positive things...

    Thanks,

    sathish.G

  • July 27, 2012 at 6:54 am

    #1518463

    OMG...... Thanking both of you...... It worked...... Enabled PAE switch and AWE for that instance.... Ram boomed to 20 gb utilization....... LOVE Both of you....... 🙂 🙂

    Thanks,

    sathish.G

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

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