SQL 2008 Memory Usage

This is normal. SQL server will always use all available memory, and scale back when the system needs more resources.

THIS article describes what is going on.

When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and Performance Monitor may show that the physical memory available on the computer is steadily decreasing until the available memory is between 4 to 10 MB.

This behavior alone does not indicate a memory leak. This behavior is normal and is an intended behavior of the SQL Server buffer pool.

By default, SQL Server dynamically grows and shrinks the size of its buffer pool (cache) depending on the physical memory load reported by the operating system. As long as enough memory is available to prevent paging (between 4 - 10 MB), the SQL Server buffer pool will continue to grow. As other processes on the same computer as SQL Server allocate memory, the SQL Server buffer manager will release memory as needed. SQL Server can free and acquire several megabytes of memory each second, allowing it to quickly adjust to memory allocation changes.

Because of the way SQL Server allocates memory (particularly with AWE enabled), Task Manager and Process Explorer will not give you an accurate indication of how much RAM it's actually using. To get the proper figures, you have to ask SQL Server directly. The easy way to do that is run perfmon, and add the counter SQLServer:Memory Manager/Total Server Memory. That counter will report the total memory usage in KB.

Now, if SQL Server is using the full 6000 MB that it's limited to, then that's perfectly normal (and desirable) behavior. If it's using substantially more than that, then there might be a problem.