I have been doing a lot of development on my gaming machine and as all gamers know, you want to have as much free RAM as humanly possible while playing games. I close all open applications, but what doesn’t help is having running services in the background doing nothing. A good example is SQL Server. So in efforts to free up more RAM while playing games I wrote the following batch files which I run as needed:
Start Script
@ECHO OFF ECHO Starting all SQL Server Services ECHO . NET START "SQL Server VSS Writer" ECHO . NET START "SQL Server (SQLEXPRESS)" ECHO . NET START "SQL Server Browser" ECHO . ECHO All Services Started PAUSE
Stop Script
@ECHO OFF ECHO Stopping all SQL Server Services ECHO . NET STOP "SQL Server (SQLEXPRESS)" ECHO . NET STOP "SQL Server Browser" ECHO . NET STOP "SQL Server VSS Writer" ECHO . ECHO All Services Stopped PAUSE
You can add any other service to this list, just make sure you know what it is that you are messing with. This is an alternative to going into the Services GUI and doing it one by one. Also please note that if you are not sure what your SQL Server Service instance is named, just look in the Services GUI to find out. I happen to be running the express edition hence the naming.
Just a quick tip.