SQL Server Performance

Memory behaviour in SQL Server 2008

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by goboxe, Mar 9, 2009.

  1. goboxe New Member

    Hi,
    I have a 8GB RAM server running SQL Server 2008 Enterprise Edition.
    I have allocated 5.5GB RAM to SQL Server. After some normal queries start hitting the server, the RAM used by SQL Server is goes up to 7.2GB.
    The strange thing is that the memory usage by SQL Server was not dropping and it kept maintained at 7.2.GB.
    I am wondering, is this is the expected behaviour of SQL Server 2008? I don't think SQL 2005/2000 behave similar way?
    Are the something that I need to turn on / off in order to see the correct behaviour.
    Thanks,
    Goboxe.
  2. MohammedU New Member

    I don't think there is any behavioural change from SQL 2005 to SQL 2008 but make you use MAX SERVER MEMORY option to limit the memory usage...
    and use PERFMON counters TOTAL SERVER MEMORY and TARGET SERVER MEMORY to check the memory consumption by SQL...

Share This Page