Post reply

SQL server memory problem

  • April 9, 2009 at 7:42 am

    #133030

    Hi Guys,

    I am currently experiencing memory issues on one of my servers. We are currently using a third party tool and the memory utilization on the box is more than 90%.

    Server Details:

    64 bit SQL server

    Windows Server 2003

    SP2

    Dual-Core AMD

    7 GB RAM

    I upgraded from a 32 bit to a 64 bit last month. Enabled the -g switch to 512.

    Should I change the max memory to a different amount? Currently it's set to 2147483647.

    Please advise on what to do.

    Regards

    IC

  • April 9, 2009 at 8:49 am

    #975116

    HI

    I would set the maximum Memory to 6GB and leave 1GB for OS, this is the case when you have only SQL server running on a server, as u mentioned you are having a 3rd party app, check how much that app needs and include that in free memory, then restart SQL server for this effect to take place, then check how much memory is been used and by which app. 🙂

  • April 9, 2009 at 8:53 am

    #975121

    Thanks for this. The app is situated on another box.

    Do I have to restart the machine after I set the memory to 6GB?

    Regards

    IC

  • April 9, 2009 at 6:09 pm

    #975517

    Yes.

    To reduce the max server memory you may need to restart SQL Server to release the memory(http://msdn.microsoft.com/en-us/library/ms178067.aspx).

    MJ

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

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