Geeks With Blogs


Add to Google

Tim Hibbard CEO for EnGraph software
Like most developers, I run SQL on my main work computer.  I find that the RAM usage gets quite bloated at times, so I have a handy bat file that I run to restart the SQL service, giving me my RAM back.  Here are the simple steps to achieving this:

1) Right click on your desktop and create a new text document.
2) Rename file to restartSQL.bat
3) Click yes on confirmation to change a file name extension.  If you did not get this error, you will need uncheck "Hide extensions for known file types" on the View tab of Folder Options.
4) Right click restartSQL.bat and select "Edit"
5) In the document that opens up, type
net stop mssqlserver
net start mssqlserver

*note if you have a named instance of SQL, change "mssqlserver" to what your instance is named
6) Close document and save changes when prompted

Now when your RAM is getting a bit high, just double click the file and it will give you your RAM back from SQL (for a little bit anyways).

P.S.  I know I've been a really bad blogger and Jeff yelled at me the other day about it.  It's annoying when people give a million excuses for not blogging for the last couple of months, so I won't do that :)

Posted on Friday, November 7, 2008 6:52 PM | Back to top

Comments on this post: RAM usage when running SQL on development machine

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Tim Hibbard | Powered by: