SQL Server will grab what it needs within the limits that you configure the server to. I believe that 6.5 will not return memory to the pool once it has grabbed it, unlike 7.0 and 2000.
-Mike
>We have three SQL Servers using SQL6.5. When we checked memory using Task Manager, we fond the SQLSERVER.EXE using memory were different. The mem usage is from 8 MG to 500 MG in different computers. Why?
>
>
>Thanks
>
>
>Jim