The problem is that I do not do database programming every day, and so I probably do not need sql server running every time my pc runs. And I have noticed that since I installed MSDE/sql server that their appears to be a lot of disk thrashing going on, and my system seems a lot slower than it use to be.
Has anyone had a similar problem? What do I need to do to shut it down if not in use? Is stopping the sqlsever.exe in task manager the proper way to shut it down?
I have 256 meg of Ram.
Thanks in advance, Amy DanoughWhat operating system are you using? For XP/2000/2003/NT, you can go into Control Panel/Administrative Tools/Services and chane the startup mode for the MSDE service (possibly still called SQL Server) to manual, and then it will start only when you manually start it.
Failing that, you can right click on the icon and then stop the MSDE when you do not need it (and right click to start it up again if need be).|||XP Professional,
Thanks for the help.
Amy|||Go to administrative tools->services and set the service's startup mode to manual. that way it won't start up with the OS. the downside is you'll have to start it manually when you need it. it'll probably be under "mssqlserver". you can start it the same way or at the command line with
net start mssqlserver
personally I've never found it to be an excessive memory hog (well, full SQL Server at least). I've run it on systems as low-grade as P233+/64Mb before now
j
No comments:
Post a Comment