Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
SQL 2008R2 Server Performance

Answered SQL 2008R2 Server Performance

  • Sunday, July 29, 2012 10:16 PM
     
     
    Sign In to Vote
    0

    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

     

All Replies

  • Sunday, July 29, 2012 10:41 PM
    Moderator
     
     Answered
    Sign In to Vote
    2

    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

    • Proposed As Answer by Elmozamil Elamir Monday, July 30, 2012 7:08 AM
    • Marked As Answer by JHITSupport Monday, July 30, 2012 11:07 PM
    •  
     
  • Monday, July 30, 2012 1:19 AM
    Moderator
     
     Answered
    Sign In to Vote
    1
    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