When running SharePoint locally it is a good idea to control the memory usage of SQL. To do this use the SQL query below.
sp_configure 'max server memory', 1024 RECONFIGURE GO
A good article that goes through some of the areas you need to look at in relationship to memory is located at: http://www.eraofdata.com/blog/2008/10/sql-server-memory-configuration/