locked
SQL 2008R2 Server Performance RRS feed

  • Question

  • Hi

    New Install of SQL 2008R2, 8GIG RAM.  I noticed all RAM is being taken by the sqlserver.exe process, leaving none.  Opening the databases and using the server is very slow.

    What can I do / start looking at in the first instance?

    Thanks
    Mark

    Sunday, July 29, 2012 10:16 PM

Answers

  • Hello,

    Please set max server memory to 4096 MB,  leaving at least 4 GB to the operating system.

    http://msdn.microsoft.com/en-us/library/ms178067.aspx (See examples section)

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Sunday, July 29, 2012 10:41 PM
  • Its expected that SQL would consume whole memory if no limit is set. Please follow Alberto's suggestion.

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    Monday, July 30, 2012 1:19 AM

All replies

  • Hello,

    Please set max server memory to 4096 MB,  leaving at least 4 GB to the operating system.

    http://msdn.microsoft.com/en-us/library/ms178067.aspx (See examples section)

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Sunday, July 29, 2012 10:41 PM
  • Its expected that SQL would consume whole memory if no limit is set. Please follow Alberto's suggestion.

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    Monday, July 30, 2012 1:19 AM