Re: Memory bug

The SQL Server will cache data and query plans and maintain them in cache
for performance reasons. There are memory management processes in SQL
Server to decide when to clear items from cache based on aging and on other
memory requirements on the system. Unless you're processes are doing
operations like loading an entire large table in cache (e.g., select * from
somebigtable), I wouldn't expect it to dominate the server's memory.

There is a configuration option to set the maximum amount of system memory
that SQL Server will use, but you shouldn't have to set it unless the SQL
Server is regularly monopolizing memory resources at the expense of other
applications or the OS.
--
Bob Pfeiff
MCDBA, MCSD, MCSE, MCT, SQL Server MVP
Practice Leader, Data Management
CIBER, Washington, DC