SharePoint likes at LOT of SQL Server memory.
For some reason, the more we deploy applications and the more we keep the system running with an hibertate-start, or pure keep-alive status, it just steels me of any memory I have.
500Mb of sql server?? 250Mb of w3wp.exe?? What for??
So I've build a simple batchfile to put the guy back to 50Mb like it should :-p
net stop "SQL Server (SQLEXPRESS)"
net start "SQL Server (SQLEXPRESS)"
or if its full sql version, not express
net stop mssqlserver
net start mssqlserver