Can I end SQL server process that is running on my PC in background ?

_{Sunday, August 14, 2011 5:15 AM}

Can I end SQL server process that is running on my PC in background when not required ? It's consuming 4.7MB of RAM. (I have only 256MB of RAM) and it's slowing down my PC. If I did end the 'sqlservr' process, will it affect the performance in anyway ?

I only require SQL server for creating database on my machine when I develop applications in DOT NET. At other times I don't need it at all. 

I am using XP performance edition SP3 and my PC is not connected to LAN. Thank you.

_{Monday, August 15, 2011 9:41 PM ✅Answered | 1 vote}

And if you decide you don't need the SQL Server, don't just kill the sqlservr.exe process. Using SQL Server Configuration Manager to stop the Database Engine service. And you can use the SQL Server Configuration Manager tool to configure the service to start manually, instead of automatically. Help with the tool is here http://technet.microsoft.com/en-us/library/ms190035.aspx

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

_{Sunday, August 14, 2011 7:54 AM}

You can stop SQL Server service, but I think your application needs to work against the database? If your machine is 32 bit you can enable \3gb in boot.ini file to restrict memory using no more than 3 gbBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/