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 Adm...