Post reply

Target Server Memory

  • September 19, 2006 at 1:09 pm

    #75063

    Can it be assumed that "Target Server Memory" is the amount of memory that SQL would use irrespective of the amount of memory allocated to sql or the limit imposed by the version of SQL installed? We have SQL2k STD installed on win2003 STD with 4GB of RAM. SQL memory utilization is currently maxed out with ~1.7GB and we are trying to get some idea of how much memory SQL wants to use should we upgrade to SQL2005 64Bit.

  • September 19, 2006 at 1:20 pm

    #661342

    Target Server Memory is the amount of memory available for SQL Server to use.  In the example you show, the Target Server Memory counter should show 1.7 GB (or something very close).  As far as how much memory SQL Server wants to use, it will want to use as much as you can give it!  What you want to do is find out if your system is experiencing memory pressure with the current amount of memory.

     

    Here is some good info on monitoring SQL Server memory:

    http://www.sql-server-performance.com/performance_monitor_counters_memory.asp

    http://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp

     

    Also look at the section here on hash/sort/etc. warnings:

    http://www.sql-server-performance.com/sql_server_profiler_tips.asp

     

    John Rowan

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

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

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