Wednesday, September 30, 2009

Memory Going Crazy | Life saver

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)"
iisreset

or if its full sql version, not express

net stop mssqlserver
net start mssqlserver
iisreset

No comments:

Post a Comment