Post reply

Max memory for Sql

  • March 13, 2017 at 4:17 am

    #319539

    hi folks

    we have a sql 2005 standard db setup on server 2008 Enterprise 32b
    AWE is configured

    server has 32 gb of memory, how much of this can sql realistically use?

    thanks

    mal

  • March 13, 2017 at 5:14 am

    #1932862

    AWE is required only if you have 32 bit OS. 
    SQL server buffer cache can use memory that you have configured in Max Memory

    You can use the total server memory to see the current utilization, where target server memory gives the configured max

    Select * from sys.dm_os_performance_counters where counter_name like '%server memory%'

    It is good for you to consider upgrading your OS and SQL server to get improved performance and benifit from new features

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • March 13, 2017 at 5:37 am

    #1932864

    I like this rule: https://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/ 

    In your case, assuming there's only one instance on the server and nothing much else is running on there, about 26 GB.

  • March 13, 2017 at 6:34 am

    #1932868

    thanks folks for input

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

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