Windows Service Management for Better Performance! OR Call it Memory Management

During development, its quite common to find out that SQL Server has eaten up all your RAM and other processes also keep ballooning.

I tried simplest workaround for that and it worked well. Just write a couple of batch files to stop the services. You add/remove services as per your liking. Here is an example file that I sometime use when I am working on Microsoft Project, Microsoft Visio or have to run Virtual Machine (VM) or when I am not in the “coding mode”:

File1: StopServicesToRunVM.bat

net stop "SQL Full-text Filter Daemon Launcher (MSSQLSERVER)"
net stop "SQL Server (MSSQLSERVER)"
net stop "SQL Server Agent (MSSQLSERVER)"
net stop "SQL Server Analysis Services (MSSQLSERVER)"
net stop "SQL Server Browser"
net stop "SQL Server Integration Services 10.0"
net stop "SQL Server Reporting Services (MSSQLSERVER)"
net stop "SQL Server VSS Writer"
net stop "SharePoint 2010 Administration"
net stop "SharePoint 2010 Timer"
net stop "SharePoint 2010 Tracing"
net stop "SharePoint Server Search 14"
net stop "IIS Admin Service"
net stop "World Wide Web Publishing Service"
net stop "Microsoft FTP Service"
pause

File2: StartServicesToUseSharePoint.bat

net start "SQL Full-text Filter Daemon Launcher (MSSQLSERVER)"
net start "SQL Server (MSSQLSERVER)"
net start "SQL Server Agent (MSSQLSERVER)"
net start "SQL Server Analysis Services (MSSQLSERVER)"
net start "SQL Server Browser"
net start "SQL Server Integration Services 10.0"
net start "SQL Server Reporting Services (MSSQLSERVER)"
net start "SQL Server VSS Writer"
net start "SharePoint 2010 Administration"
net start "SharePoint 2010 Timer"
net start "SharePoint 2010 Tracing"
net start "SharePoint Server Search 14"
net start "IIS Admin Service"
net start "World Wide Web Publishing Service"
net start "Microsoft FTP Service"
pause

So essentially, you write one file to stop all services and a counterpart to start them when you need to use those services.

Syntax:
net start “{SERVICE NAME}”
(You can go to “RUN > Services.msc” and copy the service name)

Comments

Post a Comment

Feel free to give constructive feedback or let me know if it was helpful.

Popular posts from this blog

Unable to delete Shared Services Provider in SharePoint (MOSS)

Sometimes The SSP you create in MOSS are not created properly. This can be result of interruption while SSP was being created or in result of bad migration from SPS03 or MCMS to MOSS. Symptoms: 1. In left nav of SharePoint Central Administration, the name of your new SSP will not render rather, it will show up as text. 2. If you try to delete that from the Central Admin, the Delete option is disabled. Resolution: You should delete the SSP using stsadm command line tool (NOTE: My SSP's name is "SSP" which is specified after "title" in command: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsa dm -o deletessp -title "SSP" However, if you have any dependencies, you will have to delete them first or you will get following error when you try deleting it through command line tool: An object in the SharePoint administrative framework, "SharedResourceProvider Na me=SSP Parent=SPFarm Name=SharePoint_Config&quo
Read more

The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the server trace logs.

Image
  While configuring the SharePoint 2010 for Forms Based Authentication, I encountered above error. To get the problem, I had to change “IncludeExceptionDetailInFaults” to true somewhere. But WHERE? Here is what solved my problem: Go to following path: 1. C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\SecurityToken 2. Open Web.config there. 3. Add following in the “behaviors > serviceBehaviors > behavior” node. <serviceDebug includeExceptionDetailInFaults="true"/> Now try to login and see what error it gives, off to a next error
Read more

Cannot add a SimpleContent column to a table containing element columns or nested relations

Recently I ran into a problem while dealing with DataSets. I was adding a colum to an XSD through Visual Studio desinger and it kept failing with following error: Cannot add a SimpleContent column to a table containing element columns or nested relations. This is a known issue. However, the solution is not well known :) To be simple and streight forward, I tell you the solution which I tried and it worked, 1. Note down the column names, datatypes and relationships of the table. 2. Delete the table. 3. Add new table and add columns to it. 4. Redefine relationships. Best of luck.
Read more