Closing unnecessary Windows Services for more RAM

After upgrading my old machine, I started installing my Development tools. One of the tools I use is Microsoft SQL Server 2008 for creating Databases and Business Intelligence. From my experience that tool is not very CPU or RAM friendly :) . It runs a lot of services like the Reporting service, Integration Services…etc.

I didn’t want these services to hog the computer for normal usage, so I created a simple batch file to close these unnecessary service.

To create a batch file just create a new empty text file and rename it to have the extension .bat.

In my batch file I’m shutting down MS SQL Server services and VMWare services:

net stop VMAuthdService
net stop VMnetDHCP
net stop “VMware NAT Service”
net stop “VMUSBArbService”
net stop SQLWriter
net stop SQLBrowser
net stop SQLAgent$MSSQLSERVER2008
net stop MSSQLFDLauncher$MSSQLSERVER2008
net stop MSSQL$SQLEXPRESS
net stop MSSQL$MSSQLSERVER2008
net stop MSOLAP$MSSQLSERVER2008
net stop MsDtsServer100
net stop ReportServer$MSSQLSERVER2008

Note that the SQL Services’ names are probably different on your machine. It depends on what did you call your Database’s instance name.

Here is a list of SQL Server services names.

To start the services again, just create another batch file and use “net start” instead of “net stop”.

Share
  • http://blogs.southworks.net/jpgarcia Juan Pablo Garcia

    hey dude! you’re going to kill me, we’re facing an issue with comments here @Southworks :(

    just noticed that every comment on my blog has been removed except the one I accepted yesterday thinking that was yours :S

    IT guys here are trying to figure out the issue… I leave you here me personal Email address…

    My apologies for that.
    Juan Pablo