SQL Server is designed to use lots of memory. SQL Server caches data which is often used in memory. This takes lots of memory for it to be able to do. If you need to limit the amount of memory that SQL Server can use you can use the sp_configure procedure to change the setting.
This code will change the max amount of memory to 1024 Megs. To run it connect to the database using osql or another T/SQL command executing program.
<pre>exec sp_configure ‘max server memory’, 1024