Post reply

Help with SQL memory issue

  • February 4, 2009 at 7:43 am

    #71234

    Hi - I'm new to SQL memory issues and would like some assistance/guidance in this area.

    I have a production and test server running SQL 2000 (OS - Win server 2003) with 4GB RAM. The sqlserver process is using 1.7GB on both servers. I also checked the max server memory and it returned Min. = 4MB and Max = 2147483647.

    The question is, should the max memory be capped and if so what is the recommended size? Would more memory be released for other applications? Would queries run faster?

    Any advice on this would be greatly appreciated.

    Regards

  • February 4, 2009 at 8:54 am

    #938039

    Max server memory should be configured so tht you leave 1-1.5GB of memory for OS. In case there are other applications running on this server then you need to reduce max server memory to leave enough memory for those applications.

    http://msdn.microsoft.com/en-us/library/aa196734.aspx

    MJ

  • February 4, 2009 at 10:03 am

    #938151

    Hi MJ

    Thanks for your response. In reading the article in the link you provided 2 questions came to mind.

    1. How can you tell is the SQL Server is using memory dynamically?

    2. If it is using memory dynamically do you still need to set max server memory?

    Regards

    MG

  • February 4, 2009 at 4:01 pm

    #938515

    Yes, you need to set max server memory when running under dynamic memory configuration.

    To check Right Click Server Name under EM-->Memory Tab-->...

    MJ

  • February 5, 2009 at 7:30 am

    #938840

    Ok - thanks.

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

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