Post reply

max server memory

  • November 28, 2012 at 3:56 am

    #271309

    hello experts,

    what are the basic steps to increase sql server memory,

    does it require any restart ??

  • November 28, 2012 at 4:23 am

    #1563021

    Steps to set max server memory or min server memory?

  • November 28, 2012 at 4:25 am

    #1563022

    Step 1: type set max server memory into your favourite search engine.

    John

  • November 28, 2012 at 4:32 am

    #1563023

    john,

    then??? lock pages enable permision?? and service restart, not required??

  • November 28, 2012 at 5:57 am

    #1563065

    SQL does not need to be restarted for memory changes to take effect. Once you set it you should see it show up under running values.

    Are you on a 64-bit machine? Is this a VM or physical? There are considerations to make if you are going to set lock pages in memory.

    Joie Andrew
    "Since 1982"

  • November 28, 2012 at 6:37 am

    #1563088

    Zeal-DBA (11/28/2012)

    john,

    then???

    Go for coffee?

    lock pages enable permision??

    Not required for just changing max server memorry

    and service restart, not required??

    Not required.

    I'm fairly sure I or another person has referred you to this book already. Chapter 4. http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

  • November 28, 2012 at 7:33 am

    #1563148

    widows server 2003 R2 (64 bit)

    SQL serever 2005 SP2 (64 bit)

    please let me know steps to set max server memory or min server memory.

  • November 28, 2012 at 7:35 am

    #1563151

    Yes Gail anthony suggested, and i started the chapter 4 but dint get time to complete it... :-P:-D

  • November 28, 2012 at 9:05 am

    #1563234

    Zeal-DBA (11/28/2012)

    widows server 2003 R2 (64 bit)

    SQL serever 2005 SP2 (64 bit)

    please let me know steps to set max server memory or min server memory.

    Server properties -> Memory -> Enter the desired values

    Or exec sp_configure to set the desired values.

    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

  • November 28, 2012 at 9:06 am

    #1563236

    Zeal-DBA (11/28/2012)

    Yes Gail anthony suggested, and i started the chapter 4 but dint get time to complete it... :-P:-D

    You know, just maybe the answers are in there...

    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

  • November 28, 2012 at 9:48 am

    #1563275

    Hmmmm..., Gail thanx for your valuable support... 🙂

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

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